PBI Waterfall Chart question

[Alwaysactive]

Hi, 

I'm using PBI waterfall chart that is avaible in the visualization section. I want to do the below tasks.

1. Color first bar and last total bar with same color.

2. Rename "Total" the last bar with a different Label.

How to achieve the above two? Any help is appreciated.

Thanks,

user

[Anonymous]

Hi @Alwaysactive 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[Anonymous]

Hi @Alwaysactive 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[Anonymous]

Hi @Alwaysactive 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Anonymous]

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.

[Akash_Varuna · Accepted solution]

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