conditional formatting

[tracyhopaulson]

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.

[amitjzaveri]

@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!

[DataInsights · Accepted 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).

[tracyhopaulson]

Thank you so much! This works 🙂