Waterfall Chart without relative change in breakdown

[Anonymous]

I want to create a waterfall chart that shows the amount of savings different measures created in a company. I have the category of measures as the main category in the Waterfall  chart and in the breakdown I have the colum with each secific measure. Is it possible to make it so the Total columns for each category show the sum of all previous totals and dont show the negative change?

The specific measures for each category are always different but, in the graph, it shows the measures of the previous category as a negative because they dont exist so they are a -100% change. Is it possible to remove this?

In this image I have the waterfall graph to the left and to the right the columns of each category summed with the previous categorys. Basically I want the blue bars on the waterfall chart to look like the chart on the right and to remove the red bars in the waterfall chart which are reffering to measures that dont exist in the pertinent category.

The order is the same in both charts. Between the BP24 and CF02 columns on the left shows the specific measures for Cf02, in the next interval it shows the measures for cf05 and in the next shows the measures for cf09. You can see that the first two big measures which show green in CF02 then get subtracted from the CF05 portion.

If this isnt possible with a waterfall graph is there something else that can get the effect I want?
(Edit: I just notice the bar chart on the right is wrong, the second bar should be the same size as the light blue on the third bar)

[Anonymous]

Hi @Anonymous 

Could you please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.