Forum Discussion
Slicer (Measure Count)
Hello Everyone Could you pls help me? I have the following table in PowerBi. The "Has Paid?" column is a measure. And I would like to create a slicer which displays Has paid? 1 or blank to filter ...
Hi , Anonymous
Measure cannot be used in slicer.It is recommended that you convert the measure into a calculated column and use it as a filter if possible.
In addition ，here is another workaround .
1.Create a seperate table ( use the new field "Has paid" as a slicer)2.Create a measure as below and apply it to the visual filter pane:
visual control = IF([Measure Has paid] in DISTINCT('Seperate table'[Value]),1,BLANK())The result will show as below:
You can refer to following posts for more detail:https://community.powerbi.com/t5/Desktop/Use-Measure-as-Slicer/m-p/1027997https://community.powerbi.com/t5/Desktop/Cannot-use-measure-in-slicer/m-p/166909Best Regards,
Community Support Team _ Eason
Thanks for your suggestion. Anonymous
Actually, I would like to create the slicer to give the user the option to filter the data. This is why I have asked about it
can you change the measure to a calculated column?
by the way, the user can also use the filter pane to filter the measure in the front-end.
Aiolos Zhao