Forum Discussion

mclawler's avatar
mclawler
Helper III
2 years ago
Solved

Conditional Formatting Threshold Based on Slicer Selection

I'm familiar with setting Conditional Formatting.  But I'm trying to set different parameters dependant upon the slicer selection. 

 

For example:  Without any person selected it shows the Team's metrics as a whole (560 Answered, top middle card).  If the Answered metric is above 500 for the Team I'd like the card to turn Green, and if the Answered metric for the Team is <= 500 I'd like the card to turn Red.  That's pretty standard and easy to do.  

 

I would like for the above Rule to remain in effect however, if a person on the slicer is selected then I'd like the Answered threshold to change from 500 to 75.  Or to take it even further, indidualize the threshold for each individual person.  

 

Thank you so much for your time! 

 

 

2 Replies