Forum Discussion
PBI Waterfall Chart question
Hi Alwaysactive You could achieve this by creating a custom measure for bar colors using SWITCH to assign the same color to the first and last total bars, then applying it in Data Colors. To rename "Total," create a custom column or measure using IF to replace "Total" with your desired label. Unfortunately, the default Waterfall Chart doesn’t support these changes directly.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Hi Alwaysactive
Thank you for reaching out microsoft fabric community forum.
Also, thanks to Akash_Varuna for providing helpful guidance. I would like to add a few clarifications to ensure full accuracy:
-
In the default Power BI Waterfall visual, dynamic coloring by a measure (like using SWITCH) is not supported. Only static color settings for Increase, Decrease, and Total are available.
-
Renaming the "Total" label directly is not possible through formatting options. You could restructure your data to manually create a different "Total"-like bar if needed, but it requires additional data modeling effort.
If you need more flexibility (like dynamic bar coloring or custom labels), you might want to explore custom Waterfall visuals from AppSource or create a fully customized visual using a combination of bar charts and measures.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.