Waterall with Subtotals

[Anonymous]

I need to create a waterfall chart similar to this in Power BI. Is there any way to do this with the standard waterfall chart or even in the ultimate waterfall chart? Furthermore, is the ultimate waterfall chart worth the money?

Background:

1. The total time is a measure based on a slicer selection

2. The negative categories (Business Down Time, Scheduled Down Time, etc.) are built in to the query

3. The subtotals are measures based off of the total time and the negative categores

[v-shex-msft · Accepted solution]

Hi @Anonymous,

Nope, I test with both visuals which you mentioned. I found they are not support displayed details break down label and total.

Waterfall visual:

If you haven't used 'breakdown' field, is displayed category and total correct. When you add column to 'breakdown' field, it will display and summary value as 'increase, decrease, other' labels instead display change of values and actual amount.

Ultimate waterfall chart:

I found it multiple current graph as count of each subcategory times, it also not suitable for your requirement.

Regards,

Xiaoxin Sheng

[Anonymous]

Thats what I was afraid of. 

Thank you for checking!