How to color customize a specific column in a waterfall chart

[Anonymous]

Hello all, 

New to the community and looking for some insight on a waterfall chart. Just for some context, 12051/12052 on the x axis refers to week 51/52 and MT % on the y refers to empty mile percentage. 

My question: is there anyway to visually display the "suboptimal movement" column as red when increasing, and green when decreasing - as this is a negative for the business; yet keep all other column's color green when increasing/red when decreasing etc. 

Thanks!

[Anonymous]

Hi @Anonymous ,

To my knowledge, your requirement could not be realized currently.
But this is at idea/feedback level alone. May be, hopes Power Bi will implement this in nearby future.
If you also want this in power bi, please submit Idea and vote on the website -  https://ideas.powerbi.com/ideas/

Best Regards,

Stephen Tao

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

[Pragati11]

Hi @Anonymous ,

Click on your waterfall chart, under format options you can modify colours:

Thanks,

Pragati

[Anonymous]

Hi Pragati, 

Unfortunately the changes made under "sentiment colors" will impact the entire visualization. I want to have the entire visualization to be green increasing/ red decreasing EXCEPT the "suboptimal movement" column which needs to be the inverse. 

[Pragati11]

Hi @Anonymous ,

Apologies, I somehow mis-read the last statement in your query.

You can't do that curremtly in waterfall chart.

Just to confirm your x-axis is the column moved under CATEGORY section of this visual?

Thanks,

Pragati

[Anonymous]

@Pragati11