Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Ranjith_96
Helper I
Helper I

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

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

 

Ranjith_96_1-1661515835997.png

 

 

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @Ranjith_96 ,

I created some data:

vyangliumsft_0-1661848249959.png

Here are the steps you can follow:

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

 

vyangliumsft_1-1661848249967.png

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

vyangliumsft_2-1661848249969.png

1. Create measure.

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

2. Bar color – fx

vyangliumsft_3-1661848249970.png

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

vyangliumsft_4-1661848249974.png

4. Result:

vyangliumsft_5-1661848249983.png

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

View solution in original post

3 REPLIES 3
v-yangliu-msft
Community Support
Community Support

Hi  @Ranjith_96 ,

I created some data:

vyangliumsft_0-1661848249959.png

Here are the steps you can follow:

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

 

vyangliumsft_1-1661848249967.png

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

vyangliumsft_2-1661848249969.png

1. Create measure.

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

2. Bar color – fx

vyangliumsft_3-1661848249970.png

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

vyangliumsft_4-1661848249974.png

4. Result:

vyangliumsft_5-1661848249983.png

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
Helper I
Helper I

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

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.