Power BI

Have you tried


for Microsoft Power BI

Waterfall Charts are powerful visuals that effectively display the cumulative effect of sequential positive and negative values contributing to the final total. They are also known as cascade or bridge charts and are very popular in the financial world. Some of the common use cases for waterfall charts are for visualizing the P&L statements, cash flows, expenses management, etc.

Let’s take a quick look at some of the key features of the xViz Waterfall Chart custom visual for Microsoft Power BI.

 

Key Features – Summary

1. Variance Analysis with Drilldown

2. Intermediate Sum

3. Breakdown Analysis

4. Runtime Deviation Bar

5. Breadcrumb

6. Axis Break

7. Data Label customization

8. Context Menu

9. Horizontal and Vertical Orientation

 

Key Features – Description

 

1. Variance Analysis with Drilldown

The xViz custom visual supports one of the most important use cases of a Waterfall Chart i.e. variance analysis. One can easily visualize the root cause of a problem by drill down to the lowest level and switching to a summary table in case of more details.
Waterfall Chart Custom Visual for Microsoft Power BI

2. Intermediate Sum

For certain use cases, it’s important to display a column as an intermediate sum instead of an additive column (default Waterfall Chart behavior). You can either assign a certain column to be a total column from the data source Display totals or subtotals at any point within the chart.

Waterfall Chart Custom Visual for Microsoft Power BI

3. Breakdown Analysis

The xViz Waterfall Chart supports breakdown analysis – subdivide the chart by a category field to further analyze the contribution by each segment. The two different types of breakdown scenarios are as follows:

  • Simple Breakdown
  • Running Sum Breakdown

Simple Breakdown – Similar to the Power BI Waterfall Chart breakdown scenario, where each of the breakdown categories is displayed as a variance. For example, each state represents the variance between the two time periods (the difference between Q1 and Q2 revenue)

Waterfall Chart Custom Visual for Microsoft Power BI

Running Sum – The breakdown field displays as a running aggregate to give a grand total. In the below example, each state adds up to the quarterly sales and each quarter adds up to the grand total. Thus, displaying the total revenue at each point of time.

Waterfall Chart Custom Visual for Microsoft Power BI

 

4. Runtime Deviation Bar

This helps you analyze the deviation between any two columns at runtime. You can choose to display both the difference and difference % or either one of them.

Waterfall Chart Custom Visual for Microsoft Power BI

Please note: In cases, where you would like to drill down as well as analyze the deviation between the columns, the deviation property will take precedence. The deviation property can be disabled at runtime using the context menu to enable the drill-down features.

 

5. Breadcrumb

The breadcrumb helps in understanding the levels which have been traversed to reach the current state while drilling down.

Waterfall Chart Custom Visual for Microsoft Power BI

6. Axis Break

In the case of a variance scenario, the variances tend to be very small and hard to view. The axis break property dynamically scales the Y-axis to get a better view of the variances.

Waterfall Chart Custom Visual for Microsoft Power BI

7. Data label Customization

You can customize the variance display to either show actual / percentage value or even both together with the ability to position it inside or outside the chart.

Waterfall Chart Custom Visual for Microsoft Power BI

 

8. Context Menu

The context menu is only available in case of variance analysis scenarios, catering to two important features at runtime:

  • Custom Sorting: Sort waterfall chart based on Variance and Variance %
  • Runtime Deviation: You can either drill down or activate runtime deviation. With this option, you can enable runtime deviation when needed and disable it when you want to drill down.

Waterfall Chart Custom Visual for Microsoft Power BI

Note: The context menu option is only available for variance analysis scenarios.

 

9. Chart Orientation

The xViz Waterfall Chart provides the flexibility to display both as vertical and horizontal.

Waterfall Chart Custom Visual for Microsoft Power BI

 

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