Variance Chart

For Microsoft® Power BI

The Variance Chart for Power BI provides users with the capability to compare performance and benchmark with variance visualized in both absolute & % terms. The custom visual helps you to analyze comparisons of two values across three distinct visualizations (comparison chart, variance chart and variance percentage) integrated into one visual control. The visual formatting of the Variance Chart is influenced by the International Business Communication Standards (IBCS).

Features

Conditional Formatting

The excel-like feature in Variance Chart for Power BI allows you to highlight data that meets specific conditions

Display Average Variance

Display averages for performance, benchmark, absolute variance, overall average % variance

Sorting

The chart allows you to sort values by performance, comparison, absolute variance or % variance.

RTL (Right to Left Support)

Leverage RTL Support to enhance readability of languages like Arabic, Hebrew and many more

Consolidated Tooltip

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

Enable/Disable Absolute and % Variance

The Variance chart visual gives you the option to hide either (or both) of these

Width Customization of Series

Depending on the real estate, customize width for Base Series, Absolute Variance and % Variance

Orientation

The custom visual for Power BI enables you to choose between horizontal or vertical orientation.

Custom Theme

The Variance chart custom visual allows you to switch between the Standard, Microsoft & Custom themes

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

Use Cases

Comparing “Actual vs. Planned”, “Forecast vs. Planned”, and “Forecast vs. Previous Year”

Calculation of Profit Gained by comparing Retail and Selling Price

Analysis of predicted and actual rainfall data over a period of time

Differentiation of Revenue Generated and the Overall Cost incurred for Sales.

Track employee performance by comparing their target and achieved values

Comparison of different aspects of employment across regions over a specific period

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)