How to give custom color along with automatic color coding to waterfall chart

[Ranjith_96]

Hi Power BI Community,

I have a waterfall chart. Please refer the image below, I want the automatic default color coding as  if the value is positive it has to be green and if negative it has to be red but with that i want Laptop to be in Blue color irrespective of its value ( it amy be positive or negative but it has to be in blue color).

So, Category Laptop should be in Blue color and rest of the categories color should vary according to its value.

Please someone help me in achieving this. Thanks in advance. 

Also please find the one drive URL of the dashboard.

https://1drv.ms/u/s!AvQPa0SWoli2gQKOR_wkl2e7VPQE?e=mT1smg

[v-yangliu-msft · Accepted solution]

Hi  @Ranjith_96 ,

I created some data:

Here are the steps you can follow：

If you want to customize bar color, you can try Simple Waterfall.

You need set ‘Format using Sentiments’ to off, and then customize bar color.

1. Create measure.

Color =
IF(
    MAX('Table'[Group])="Laptop","blue",
    IF(
    MAX('Table'[Amount])>=0,"green","red"))

2. Bar color – fx

3. Go to the Bar color interface and set to the following.

4. Result:

If you need pbix, please click here.

How to give custom color along with automatic color coding to waterfall chart.pbix

Best Regards,

Liu Yang

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

[Ranjith_96]

@amitchandak @lbendlin  @tamerj1 @Ashish_Mathur ..........if you can look and confirm if its possible or not..would be helpful....

[tamerj1]

Hi @Ranjith_96 
I'm no expert in visuals but I believe conditional formatting is not available yet for water fall charts. Let's see what the experts would have to say about that.