Forum Discussion
Measure as a Slicer
Hi Guys,
Do you have maybe an idea how a measure could be used as a Slicer?
In my device inventory data, there are some cases where multiple users are logged into the same devices. I created a measure called "Max User" which holds the username of who is logged into the device more frequently.
| DeciveID | Max User |
| 1 | A |
| 2 | B |
| 3 | C |
| 4 | D |
| 5 | E |
Now I would like to create a Slicer, based on this measure so that I can filter some visuals based on the username. However, I am unable to put the measure as a slicer.
I would appreciate your help on this.
TIA!
Hi Anonymous ,
The measure CAN NOT be applied the slicer. You can create a measure to get a flag which can judge if the user can be displayed or not, and apply a visual-level filter on the visual with the condition(like Flag is 1)... You can refer the following links to get it:
Show most 5 recent records based on date and team nameMeasure as Slicer - Workaround?
How to use a measure with a slicer in power bi
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
And it is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community.
How to upload PBI in Community
Best Regards
1 Reply
Hi Anonymous ,
The measure CAN NOT be applied the slicer. You can create a measure to get a flag which can judge if the user can be displayed or not, and apply a visual-level filter on the visual with the condition(like Flag is 1)... You can refer the following links to get it:
Show most 5 recent records based on date and team nameMeasure as Slicer - Workaround?
How to use a measure with a slicer in power bi
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
And it is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community.
How to upload PBI in Community
Best Regards