Waterfall Chart is not showing decreases

[Natalia5858]

Hi everyone, 

This is my dataset

The problem here is that at the moment i use a waterfall chart is summarizing the January Planned ammount ($7,000) into only the inventory cost savings instead of showing $12k in the Inventory Savings sectuon and %5,000 in the Equipment Investment section. What can i do?

[v-jingzhang · Accepted solution]

Hi @Natalia5858 

You just need to move the Indicator column from Breakdown to Category on the waterfall chart. Just like below. Then expand the chart to Indicator level. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[ShazaibShoukath]

Hi, I'm also using the same waterfall chart, But I can't see the data drill down or expand feature in the power BI dasktop. 

[v-jingzhang]

Hi @ShazaibShoukath 

Do you select the visual? If already yes, check whether these icons are turned on from Properties > Header icons > Icons. 

Best Regards,
Jing

[ShazaibShoukath]

Yes i have able all the icon but i cant see it here is an screenshot for ref 

[v-jingzhang]

It seems all header icons are missing on the visual. Are you using the built-in waterfall chart visual or a custom waterfall visual? Which version of Power BI Desktop are you using?

[ShazaibShoukath]

Version: 2.118.828.0 64-bit (June 2023)

I have all the header but just for seucity issues i have made line in red color 

[v-jingzhang]

Hi @ShazaibShoukath 

Have you added two fields to Category of the waterfall chart? If there is only one field here, drill down/drill up/expand icons won't appear. 

Jing