Conditional formatting based on another table

Hello NOVICE02 

Conditional formatting sometimes is tricky in Power BI, especially when you want to involve multiple tables.

There could be multiple ways of doing it, but the way I do it is by creating a measure for defining the color:

Color AHT = 
SWITCH (
    TRUE (),
    ISBLANK ( [tgt AHT] ), "#C0C0C0",
    [Avg Handle Time] <= [tgt AHT], "#008000",
    [Avg Handle Time] > [tgt AHT], "#f08080"
)

In the example above, I am comparing two measures: [Avg Handle Time] against [Aht target] which are in two separate tables.

Once this measure is created, apply the following steps in conditional formatting :

Format by > Field Value

Then select the measure created above:

Regards,
Vivek

If it helps, please mark it as a solution

Kudos would be a cherry on the top 🙂

https://www.vivran.in/