Forum Discussion
Reverse Slicer
Hello
Please I need your help.
I am doing a report in PowerBi in live connection.
The model is in an azure analysis service and I am devolopping report with PowerBi.
In my report I have 2 slicers that are duplicated ( I am using them like a role playing dimension)
The slicers are like that:
1rst Slicer and 2nd Slicers
A A
B B
C C
D D
I want that when I Select "A" in the 1rst slicer I will have in the 2nd slicer the values except "A".
2nd Slicer
B
C
D
The goal is to prevent the user from selecting the same value in both slicers
What I want is like a reverse slicer.
Do you know how I could do it ?
Thanks for your help.
Anonymous ,
I'm afraid the defauly slicer chart in power bi doesn't allow this function. However, as a workaround, you may rebuild the two columns 'Slicer1' and 'Slicer2' like pattern below:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- Greg_Deckler
Community Champion
I created a couple different versions of something like that:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Selector/m-p/648290
https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266
Let me know if those will work or not.
Hello Greg_Deckler
Thank you for your answer.
I tried to use this versions https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Selector/m-p/648290
but it doesn't work for my case because I can't use a calculated measure in a slicer. :-(
Do you know how to convert this calculated measure in a calculated column ?
Thank you for your help.
v-yuta-msftCommunity Support
Anonymous ,
I'm afraid the defauly slicer chart in power bi doesn't allow this function. However, as a workaround, you may rebuild the two columns 'Slicer1' and 'Slicer2' like pattern below:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
