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 they are above 100. The slicer is connected to a simple table with no connections in the model, just a range of numbers really.

 

Is this possible?

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.

2 Replies

  • 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.