conditional Formatting based on other measures

Question

Hi everyone,&nbsp;I am looking to conditional format a card dependent on another different measure and have that conditional formatting change dependent on the slicers.&nbsp;My slicer is for the teamsTeam A's Target - 700kTeam A's Closed Business - 600kTeam B's Target - 650kTeam B's Closed Business - 660k&nbsp;Ideally this is what I want:&nbsp;If I select team A, I will see the two cards like so:700&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; 600Target&nbsp; &nbsp;&nbsp;|&nbsp; Actual&nbsp;But if I change my view to team B, I will see:650&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp;&nbsp;660Target&nbsp; &nbsp;&nbsp;|&nbsp; Actual&nbsp;Is this possible? I can only seem to be able to do this by hardcoding the values, which wouldn't work in this situation.&nbsp;Thanks!

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,I went ahead and created a little data set in excel:&nbsp;&nbsp;&nbsp;&nbsp;I created a slicer for team&nbsp;Then I created a measure:Conditonal Format Flag = if(max(Sheet1[Target])&gt;max(Sheet1[COB]),1,-1)Then going under the card visualization, select &gt; Format&gt;Data Label&gt;the little elipses by Color&gt;Condtional Formatting.&nbsp;From there Format by: RulesBased on field: Condtional Format Flag&nbsp;Rules:If values is 1 then Red (under target)If value is -1 then Green (on or over target)&nbsp;&nbsp;Hope this helps!&nbsp;Caleb Foster

Forum Discussion

conditional Formatting based on other measures

2 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting