Hierarchical Variance Table for Power BI

by | Aug 27, 2019 | xViz

Note: This visual will be available in the AppSource only in the first week of September 2019. To get the latest build, reach out to us here.

The xViz Hierarchical Variance table provides the ability to the user to view and analyze hierarchical data with much more detailing added to it. The extensive list of features lets you to consume business trends, hierarchies and different forms of data all at once and view it in a much appealing visual form.

I will be using a Sales Performance Dataset to showcase the key features of xViz Hierarchical Variance table. The dataset has two measures viz., Sales Budget and Sales Forecast values for a period of 12 months. The categorical hierarchy has Region, Category & Sales Representatives.

Key Features – Summary

1. Expand/Collapse-enabled hierarchical table

2. Track absolute & percentage variance for each level in the hierarchy

3. Track percentage contribution by level

4. Display sparkline chart to show performance across time periods

5. Show/hide overall total

6. Search across hierarchy levels

7. Semantic formatting

8. Conditional formatting

Key Features – Description

1. Expand/Collapse-enabled hierarchical table: Without the need to drilldown, you can view all the levels of data at once on the Hierarchical Variance table. As and when you add more categorical fields into the report, it gets added as an additional level on the hierarchy.

Hierarchical Variance Table for Power BI

2. Track absolute & percentage variance for each level in the hierarchy: As I have added two measures – Sales Budget & Sales Forecast, the xViz variance table calculates the Absolute Variance, % Variance at every level of the hierarchy irrespective of the level at which the data is added.

3. Track percentage contribution by level: The contribution % of each member to its parent is also another important detail that is shown to the users by default in the hierarchical variance table.

4. Display sparkline chart to show performance across time periods: Any Period field can be added to the category to add it into the hierarchy. But, when the period field is added into the Time Period, a sparkline appears beside every member to display the trend of the data.

Hierarchical Variance Table for Power BI

5. Show/Hide Overall Total by toggling the Display Totals option under Table Options.

Hierarchical Variance Table for Power BI

6. Search & Filter across hierarchy levels: Hierarchy Variance Filter comes with an advanced search option which lets you to search and filter by just typing in the text.

Hierarchical Variance Table for Power BI

7. Find & Seek for members at any level: For this, you will need to switch the search option to Find & Seek. This is very different from the Filter option as it just takes you to the specific member that you’re searching for.

xViz Custom Visuals for Microsoft Power BI

8. Semantic formatting can be used to visually differentiate positive and negative values based on your enterprise needs.

Hierarchical Variance Table for Power BI

9. Percentage Variance based Conditional formatting is applied to each member by default. This can be controlled by using the % Variance threshold under the Conditional Formatting Section .

xViz custom Visuals for Microsoft Power BI

We have covered the key features of xViz Hierarchical Variance Chart so far but there is more. To get the latest version of the custom visual, reach out to us here.

You can take a look at the other advanced custom visuals by xViz here.

Get Started with xViz today!

Try xViz to instantly visualize the power of business optimization.