Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I need to set conditional format to show 3 different colors as shown below in a small sample data but cannot figure out how to do it in Power BI. Can someone please help? Thanks in advance for your time.
Solved! Go to Solution.
@tracyhopaulson, try this measure:
Formatting Color =
SWITCH (
TRUE (),
[Counted] = 0
&& [Not Counted] > 0, "Red",
[Counted] > 0
&& [Not Counted] = 0, "Green",
[Counted] > 0
&& [Not Counted] > 0, "Yellow"
)
Steps to apply:
1. Conditional formatting > Background color
2. Format by = Field value
3. Based on field = Formatting Color
Instead of the color names, you can use color codes (e.g., #FF0000).
Proud to be a Super User!
@tracyhopaulson You can click the down arrow button on the required field and then select Conditional Formatting for defining formatting as per your requirement.
Here is a detailed article if you want to learn different ways: https://www.mssqltips.com/sqlservertip/6265/power-bi-conditional-formatting-for-matrix-and-table-vis...
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Cheers!
@tracyhopaulson, try this measure:
Formatting Color =
SWITCH (
TRUE (),
[Counted] = 0
&& [Not Counted] > 0, "Red",
[Counted] > 0
&& [Not Counted] = 0, "Green",
[Counted] > 0
&& [Not Counted] > 0, "Yellow"
)
Steps to apply:
1. Conditional formatting > Background color
2. Format by = Field value
3. Based on field = Formatting Color
Instead of the color names, you can use color codes (e.g., #FF0000).
Proud to be a Super User!
Thank you so much! This works 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |