Forum Discussion
Showing Common values
- I have a slicer which has 3 groups Group1 , Group2, Group3.
- In table there are many users and few users belongs to 2 groups or 3 groups.
- In the slicer selection if I select group 1 , it will show group 1 users if I select group 1 and 2 it will show all users exist in group 1 and 2
My requirement/doubt
1. when I choose group 1 and 2 from Slicer, my report should show only users belongs to or present in 1 and 2 both (like show only common users among groups)
- Anonymous5 years ago
Hi Anonymous ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
In addition, you can refer the content in the following blog to achieve it:
Apply AND Logic to Multiple Selection in DAX Slicer
Changing “OR” to “AND” Logic for Power BI Slicers
Best Regards
1 Reply
- AnonymousNot applicable
Hi Anonymous ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
In addition, you can refer the content in the following blog to achieve it:
Apply AND Logic to Multiple Selection in DAX Slicer
Changing “OR” to “AND” Logic for Power BI Slicers
Best Regards