Blogs / Microsoft / Power BI / Custom Visuals / Variance Chart – Custom Visuals for Microsoft Power BI

Variance Chart – Custom Visuals for Microsoft Power BI

Aug 10, 2019

SHARE

xViz Pro Suite Visuals are completely free with all the pro features unlocked for Power BI Desktop! Leverage the full potential of xViz Suite by downloading them here.

Note: This blog addresses some features that will be available in the App Source in Sep 2019. To get this latest build, reach out to us here.

The xViz Variance Chart for Power BI provides users with the capability to compare performance and benchmark with variance visualized in both absolute & % terms.

In this blog, let us look at how Variance Chart can be used and review some of its key features as shown below:

KEY FEATURES – SUMMARY

  1. Choose horizontal or vertical variance chart
  2. Sort by Variance
  3. Conditional Formatting
  4. Ability to enable/disable absolute variance or % variance series
  5. Customize the width of the three series (base series, absolute variance, % variance)
  6. Display average variance
  7. Leverage RTL (Right-to-Left) support for languages such as Arabic
  8. Capture “Negative Variance is Good” scenarios by changing colors
  9. Customize # of data series to be displayed by default (with the rest available upon scroll)
  10. Use a Custom Theme
  11. Consolidated tooltip

USING THE VARIANCE CHART

  • Import the xViz Variance Chart custom visual from the Marketplace.
Variance Chart – Custom Visuals for Microsoft Power BI
  • Assign the fields as shown
Variance Chart – Custom Visuals for Microsoft Power BI
  • The variance chart will render the results as follows. By default, values are sorted by descending order of the primary performance value (Sales Forecast)
Variance Chart – Custom Visuals for Microsoft Power BI

KEY FEATURES – DESCRIPTION

Now let’s take a quick look at some of the key features:

1. Orientation:

Choose between horizontal and vertical alignments. The horizontal orientation is shown below.

Variance Chart – Custom Visuals for Microsoft Power BI

2. Sorting:

Sorting by performance, comparison, absolute variance or % variance. In the image below, the values are sorted in descending order of % variance.

Variance Chart – Custom Visuals for Microsoft Power BI

3. Conditional Formatting:

Invoke the advanced editor using the icon and set up excel-like conditional formatting. In the visual attached, we are calling attention to Sales Forecast that is higher than a certain value.

Variance Chart – Custom Visuals for Microsoft Power BI

4. Enable/Disable absolute variance or % variance series:

Sometimes we prefer to view only one type of variance – absolute or %, but not both.  In such cases, the Variance chart visual gives you the option to hide either (or both) of these.

In the below example, the Absolute Variance Series has been turned off. This property is available under ‘Chart Options’.

Variance Chart – Custom Visuals for Microsoft Power BI

5.  Customize the relative width of the three series:

Depending on the real estate, you can also decide which of the three series needs to have higher prominence.

Variance Chart – Custom Visuals for Microsoft Power BI

6. Display Averages:

Display averages for all the entries – including performance, benchmark, absolute variance, and overall average % variance. This property is available under ‘Chart Options’.

Variance Chart – Custom Visuals for Microsoft Power BI

7. RTL Support:

RTL support is used to enhance the readability of right-to-left languages like Arabic & Hebrew. This can be enabled by using the “Enable RTL Support” option under the Legend properties.

Variance Chart – Custom Visuals for Microsoft Power BI

Enabling this option enhances readability as shown.

Variance Chart – Custom Visuals for Microsoft Power BI

8. Capture “Negative Variance is Good” scenarios by changing the order of the colors:

Note that the positive variances are highlighted in red. This can be used to track whether your expenses are within or beyond budget.

Variance Chart – Custom Visuals for Microsoft Power BI

9. Customize the number of data series to be displayed by default:

This gives you the flexibility to adjust the display based on the real estate available for your visual. Notice the larger scroll required for the chart on the right.

Variance Chart – Custom Visuals for Microsoft Power BI

10. Use the Custom Theme:

The Variance chart custom visual allows you to switch between the themes in which you want to look at the visual. You can switch between the Standard, Microsoft & Custom themes, the examples of which are shown in the order below;

Variance Chart – Custom Visuals for Microsoft Power BI

11. Consolidated tooltip:

The tooltip of the custom visual is also consolidated, allowing you to view all the data at once.

Variance Chart – Custom Visuals for Microsoft Power BI

We have covered some of the key features above, but there’s more to explore. To get the latest version of the custom visual, reach out to us today here.

You can take a look at the other advanced custom visuals by xViz here. This blog has been originally published on xViz website. Click here to visit and know more about custom visuals for Microsoft Power BI.


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This Blog!

Share this blog with your friends and colleagues!