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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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