Forum Discussion
How to conditionally format native waterfall chart?
Hi Guys,
is there any trick to do this?
If not, what is a fully free alternative for this chart?
I am not interested in any paid charts. It is enough that I am paying a lot for power bi subscriptions
Best,
Jacek
Hi jaryszek ,
Native Power BI waterfall charts do not support conditional data color formatting based on dynamic values or measures beyond fixed sentiment categories (Increase/Decrease green/red, Total blue, Other gray).
You could try to use a stacked column chart hack, see this video if it may help: youtube.com/watch?time_continue=1&v=Ju4y98yU2KE&embeds_referring_euri=https%3A%2F%2Fwww.perplexity.ai%2F&embeds_referring_origin=https%3A%2F%2Fwww.perplexity.ai&source_ve_path=MjM4NTE
If this has helped please feel free to mark it as a solution and give kudos 👍
4 Replies
Hi jaryszek ,
Native Power BI waterfall charts do not support conditional data color formatting based on dynamic values or measures beyond fixed sentiment categories (Increase/Decrease green/red, Total blue, Other gray).
You could try to use a stacked column chart hack, see this video if it may help: youtube.com/watch?time_continue=1&v=Ju4y98yU2KE&embeds_referring_euri=https%3A%2F%2Fwww.perplexity.ai%2F&embeds_referring_origin=https%3A%2F%2Fwww.perplexity.ai&source_ve_path=MjM4NTE
If this has helped please feel free to mark it as a solution and give kudos 👍
Thank you great work around!
Best,
Jacek
Hi jaryszek
Can you please clarify what exactly you want to apply conditional formatting to?
If you want conditional formatting for the column colors in the native waterfall chart, unfortunately, that is not supported. The color of each bar in a waterfall is fixed based on its type (increase, decrease, total) and cannot be dynamically changed.
However, if you want conditional formatting for the numeric data labels (the values displayed on or above the bars), that is possible. You can set rules to change the font color of these labels based on their values.
Important note:
If you apply conditional formatting to the data labels, the color will be applied based on the smallest range value in your conditional formatting rule settings, which might not always align intuitively with the bar's purpose or value.
Additionally, for conditional formatting to work properly, you must set the data label position to "Outside" (Format pane → Data labels → Position → Outside). Conditional formatting may not apply correctly or may be unavailable if labels are set to "Inside" or "Auto".
Thank you very much!
