conditional Formatting based on other measures

[Anonymous]

Hi everyone,

I am looking to conditional format a card dependent on another different measure and have that conditional formatting change dependent on the slicers.

My slicer is for the teams

Team A's Target - 700k

Team A's Closed Business - 600k

Team B's Target - 650k

Team B's Closed Business - 660k

Ideally this is what I want: 

If I select team A, I will see the two cards like so:

700         |       600

Target    |  Actual

But if I change my view to team B, I will see:

650         |       660

Target    |  Actual

Is this possible? I can only seem to be able to do this by hardcoding the values, which wouldn't work in this situation.

Thanks!

[Anonymous · Accepted solution]

Hi @Anonymous ,

I went ahead and created a little data set in excel:

I created a slicer for team

Then I created a measure:

Conditonal Format Flag = if(max(Sheet1[Target])>max(Sheet1[COB]),1,-1)

Then going under the card visualization, select > Format>Data Label>the little elipses by Color>Condtional Formatting.

From there

Format by: Rules

Based on field: Condtional Format Flag

Rules:

If values is 1 then Red (under target)

If value is -1 then Green (on or over target)

Hope this helps!

Caleb Foster

[Anonymous]

It worked! Thanks for the help 🙂