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
The table below gives an idea of the exclusive features for visuals shipped in the Pro version of xViz suite.
| Pro Features | Variance Chart | Multiple Axes Chart | Hierarchical Tree | Hierarchical Filter | Hierarchical Variance Table | Linear Gauge | Advanced Gauge | Gantt Chart | Bullet Chart | Parallel Coordinates | Marimekko Chart | Horizon Chart | Tag 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.
