Hierarchical Variance Table – xViz

Hierarchical Variance table provides user the ability to view and analyze hierarchical data

The xViz Hierarchical Variance table provides user the ability 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.

KEY FEATURES

  • Expand/Collapse-enabled hierarchical table
  • Track absolute & percentage variance for each level in the hierarchy
  • Track percentage contribution by level
  • Display sparkline chart to show performance across time periods
  • Show/hide overall total
  • Search across hierarchy levels
  • Semantic formatting
  • Conditional formatting

USE CASE

When you deal with data of different levels, e.g. Region, Category & Sales Representatives, it’s possible to fit them in different hierarchies and view all data at once. Cases such as these call for a Hierarchical variance table.

Add-in capabilities

When this add-in is used, it
Can read and make changes to your document
Can send data over the Internet

Membership


***** Related Blog Posts *****
Creating Multi Threaded Dynamic Visuals – Advanced Power BI Technique
Custom Dynamic Segmentation Using DAX In Power BI

***** Related Video Tutorials *****
Create Dynamic Visuals Based On Ranking in Power BI w/DAX

Outlier Detection & Visualization in Power BI – Advanced DAX
How To Use Virtual Tables With COUNTROWS in Power BI – DAX Formula Technique
RANKX Considerations – Power BI & DAX Formula Concepts
Manufacturing Operations – Power BI Showcase

Center of Excellence

***** Related Course Modules *****
Ultimate Beginners Guide to Power BI
Power BI Super Users Workshop
Solving Analytical Scenarios w/ Power BI & DAX
Advanced Analytics in Power BI
Financial Reporting w/ Power BI
Power BI Showcases

***** Related Support Forum Posts*****
Custom Visual AppStore
Custom Visuals vs Standard Visuals
Power BI – Creativity