Forum Discussion

matt_s's avatar
matt_s
Frequent Visitor
7 years ago
Solved

Fetch value from slicer

I would like to use the value from a slicer dropdown and use it for conditional formatting. Let's say a user has selected 100 in the dropdown. Then all values in a certain column should be green if t...
Need Help
  • dax's avatar
    dax
    7 years ago

    Hi matt_s

    You could try below measure

     IF(SELECTEDVALUE(slicer[v])<=SELECTEDVALUE('Table'[amount]),"#2AC9C9","#C6CC1F")

    Then use this measure to define conditional format like below

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

matt_s's avatar
matt_s
Frequent Visitor
7 years ago

One step further, I have managed to get this into a measure and to return either 0 or 1. But the measure is not available to choose as a field in the conditional formatting rules?

 

NewMeasure = IF(SELECTEDVALUE(Slicer) < Table[Field]);"1";"0")
dax's avatar
dax
Community Support
7 years ago

Hi matt_s

You could try below measure

 IF(SELECTEDVALUE(slicer[v])<=SELECTEDVALUE('Table'[amount]),"#2AC9C9","#C6CC1F")

Then use this measure to define conditional format like below

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.