Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 the ones which are blank.
Is there a way to insert this measure into a slicer?
Name | Address | Has Paid? | total records |
xxxxxx | yyyyy | 1 | 1 |
aaaa | bbbb | 1 | |
ccccc | dddd | 1 | 1 |
ddddd | eeee | 1 | |
ddddd | rrrrrr | 1 | 1 |
Solved! Go to Solution.
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:
@Anonymous ,
Can you please share the DAX for your measure so we can try to convert it into Column.
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:
Hello @Tahreem24
See the DAX below
@Anonymous
Try copying the same in Column and use in the slicer.
Hi @Anonymous ,
You can try to put the measure into the filter pane on the right side.
Then you can filter the measure.
Aiolos Zhao
Proud to be a Super User!
Thanks for your suggestion. @AiolosZhao
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
Hi @AiolosZhao
From a user point of view, it will be more user friendly to have a slicer on top of the table which allows the user to filter.
Thanks for your suggestion, anyways
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
Proud to be a Super User!