Conditional Formatting Threshold Based on Slicer Selection

[mclawler]

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! 

[amitchandak · Accepted solution]

@mclawler , Create a measure based on requirement and use that in field value based conditional formatting

If (calculate(isfiltered(Table[person]), allselected()), if([Measure] < 75, "red", "green") , if([Measure] < 500, "red", "green") )

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

[mclawler]

This worked beautifully!!  Thank you