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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
amirabedhiafi
Impactful Individual
Impactful Individual

Color min and max value in a bar chart

I have the following bar chart : 

 

Captur.PNG

 

I want to color the max and the min bar chart with red and green respectively  when choosing any filter.

So De Ruyter will be in red and New Britain in green.

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini
1 ACCEPTED SOLUTION

Hey @amirabedhiafi ,

the conditional formatting has moved :-), I'm sorr for the inconvenience. Here you can add the measure that colors the min and the max value:

TomMartens_0-1607371782173.png

Hopefully, this is what you are looking for.

 

Regards,

Tom



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

View solution in original post

5 REPLIES 5
Johanno
Continued Contributor
Continued Contributor

To set color by value depending on the filtered value, create a measure like:

 

Color coding = 
SWITCH (SELECTEDVALUE('Table'[Country]),
        "New Britian", "#00ff00",
        "De Ruyter", "#ff3300"
)

 

 

Then set color by using fx - format by "Field value" - Based on field Color coding (or the name of the measure)

 

Is that answer to the question?

How do you do this using a maximum and minimum variable? Suppose "New Britian" is the minimum, and vice versa.

TomMartens
Super User
Super User

Hey @amirabedhiafi ,

 

I assume the answer in this article contains what you are looking for: Solved: Re: Highlight max value in column chart - Microsoft Power BI Community

 

Regards,

Tom



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

Hey @TomMartens  I can't find the Advanced Controls in Data Color with the latest update of PowerBI.

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini

Hey @amirabedhiafi ,

the conditional formatting has moved :-), I'm sorr for the inconvenience. Here you can add the measure that colors the min and the max value:

TomMartens_0-1607371782173.png

Hopefully, this is what you are looking for.

 

Regards,

Tom



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

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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