Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Conditional Colors

I created a bar chart with a limit line, but each bar is from a different base that I did the data modeling.

I am not finding the option to make a conditional color that if it is greater than the boundary line turns red, if it is less than the boundary line turns green.

can you help me ?




You do not have the option of conditional formatting in colors.




Super User III
Super User III

Re: Conditional Colors

Hey @Gabrielm97 ,


this is simply not possible, as Power BI does not allow to change the fill color if the color is used for identifying the single "member" inside a cluster. The fill color will be automatically applied to the members inside a cluster, based on the color in the legend (the single member). It's not possible to overwrite the fill color using conditional formatting.


Maybe, you will create an idea on




Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.



Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors