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 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 the 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 drill-down, 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-custom-visuals-microsoft-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-custom-visuals-microsoft-power-bi

 

5. Show/Hide Overall Total
By toggling the Display Totals option under Table Options.hierarchical-variance-table-custom-visuals-microsoft-power-bi

 

6. Search & Filter across hierarchy levels
Hierarchy Variance Filter comes with an advanced search option which lets you search and filter by just typing in the text.hierarchical-variance-table-custom-visuals-microsoft-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.hierarchical-variance-table-custom-visuals-microsoft-power-bi

 

8. Semantic formatting
Semantic formatting can be used to visually differentiate positive and negative values based on your enterprise needs.hierarchical-variance-table-custom-visuals-microsoft-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.hierarchical-variance-table-custom-visuals-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 here. This blog has been originally published on xViz website. Click here to visit and know more about custom visuals for Microsoft Power BI.

Subscribe to our Newsletter

5920 Windhaven Pkwy
Plano TX 75093.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com