Reply
Regular Visitor
Posts: 39
Registered: ‎10-09-2018
Accepted Solution

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. 


Accepted Solutions
Highlighted
Community Support Team
Posts: 7,656
Registered: ‎05-02-2017

Re: Measure Slicer

Hi @ns_powerbi,

 

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

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

View solution in original post


All Replies
Super User
Posts: 1,627
Registered: ‎07-03-2015

Re: Measure Slicer

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

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Highlighted
Community Support Team
Posts: 7,656
Registered: ‎05-02-2017

Re: Measure Slicer

Hi @ns_powerbi,

 

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

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