Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
I have the following bar chart :
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.
Solved! Go to 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:
Hopefully, this is what you are looking for.
Regards,
Tom
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.
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
Hey @TomMartens I can't find the Advanced Controls in Data Color with the latest update of PowerBI.
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:
Hopefully, this is what you are looking for.
Regards,
Tom
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
141 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
73 | |
66 | |
60 |