Hierarchical Variance Table

For Microsoft® Power BI

The Hierarchical Variance table for Microsoft Power BI provides user the ability to view and analyse 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. The inbuilt arithmetic capabilities of this custom visual provide the absolute and percentage variance values along with the contribution of each member in the hierarchy.


Conditional Formatting

% Variance Based on Conditional Formatting is applied to each member by default and the % Variance Threshold can be controlled.

Track Absolute and % Variance

The table calculates the Absolute Variance, % Variance at every level of the hierarchy irrespective of the level at which the data is added.

Track % Contribution

The contribution percentage of each member to its parent is also another important detail that is shown to the users by default.

Semantic Formatting

This feature enables you to visually differentiate positive and negative values based on your enterprise needs.

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.

Display Sparkline

When Time Period is added to Hierarchical Variance Table, a sparkline appears beside every value to display the trend of Data

Search, Filter, Find, Seek

Advanced Search Option in the Hierarchical Variance Table lets you search and filter important specific data present in the table.

For any feature requests or questions about this advanced custom visual, please write to us at community.xviz.com

Use Cases

When you deal with data of different levels, e.g. Region, Category, etc. fit them in different hierarchies and view all data at once.

Sales Peaks can be easily spotted using the Sparkline Feature of Hierarchical Variance Table

Calculation of Profit by comparing Revenue and Budget Values hierarchically

Other Custom Visuals in xViz Suite

The table below gives an idea of the exclusive features for visuals shipped in the Pro version of xViz suite.

Pro Features enable unique Power BI UX experiences across the xViz Suite of visuals for one price.
Pro FeaturesVariance ChartMultiple Axes Chart Hierarchical Tree Hierarchical Filter Hierarchical Variance Table Linear Gauge Advanced GaugeGantt ChartBullet ChartParallel CoordinatesMarimekko ChartHorizon ChartTag cloud  
Number Formatting-
Adv.Editor/Conditional Formatting------
Sort by anything other than default value----------
Limited to 10 data series-----------
Customize plot area width------------
Show average------------
Expand On-Demand -----------
Hide absolute,percentage variance,comparison/actuals------------
No. of orienations,min/max angle,Remove special characters,Split words-----------
Qualitative Comparitive Bands------------
Target Marker Customization------------
Data label-Height and width----------
Using Height and width------------
Context menu-----------
More than 3 categories, Search, Using time period, Max 200 rows-------
Using more than 2 measures
Gauge options (Entire Section)-----------
3-D Mode-------------
Custom Data Labels------------
Find & Seek Search ----------
Filtering through Search----------
Multi-mode visual------------
Minimap Feature------------

Get Started with xViz today!

Try xViz to instantly visualize the power of business optimization.

(No credit card required)