Forum Discussion

jaryszek's avatar
jaryszek
Super User
7 months ago
Solved

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 sub...
Need Help
  • MattiaFratello's avatar
    MattiaFratello
    7 months ago

    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 👍

MattiaFratello's avatar
MattiaFratello
Super User
7 months ago

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 👍

jaryszek's avatar
jaryszek
Super User
7 months ago

Thank you great work around! 

Best,
Jacek