Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

conditional Formatting based on other measures

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    It worked! Thanks for the help :)