Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Measure Slicer

Hi all,

 

I have a measure here:

IF([actual] = 0, IF([Target] = 0, 20,15),IF([Target] = 0,10,5))

And I want to have a slicer based on the measure, but it does not work. 

 

Please help. 

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    Maybe you need something else. If the 20 is selected, what will happen? Perhaps it doesn't have anything related to a slicer.

     

    Best Regards,
    Dale

2 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    7 years ago

    You can’t place a measure in a slicer. You can only place a column in a slicer. 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

     

    Maybe you need something else. If the 20 is selected, what will happen? Perhaps it doesn't have anything related to a slicer.

     

    Best Regards,
    Dale