Forum Discussion
Reset table selection when changing slicer value
Hello,
in my simplified model I have a Slicer with label type and the table with solution names.
In the view below the table is filtered by MANDATORY label type and I also filter other visuals by the solution AGV.
Now when I change the label type to SPECIFIC, the AGV seems still to be selected in the table. And because of the fact there is no AGV with SPECIFIC label, the other visuals are blank or error.
The question is as follows. Can I model this in a way, that changing the label type in the Slicer resets the selecion of the table?
Thanks for any support 🙂
Hi Anonymous
No, but you can add a button "clear selections" , and create the wanted functionality by replacing visuals via buttons.
The guide for the creation is here :https://www.youtube.com/watch?v=GnPuU3X74SY&t=264s
I also created an example for you, the pbix is attached.
Note that there is 2 sheets :
1 . Showing how it works2. with all visuals visible to let you follow the settings that I created :
You need the same interaction format between 2 tables :More information about interactions is here :
https://www.youtube.com/watch?v=MW_VzfNRzxg
And you need to switch off the V from data at the bookmarks :
More information about this is here :
https://www.youtube.com/watch?v=mLs1YuIkqls&t=44s
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
2 Replies
Hi JRoj,
Why not add a slicer with Solution names?
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
Hi Anonymous
No, but you can add a button "clear selections" , and create the wanted functionality by replacing visuals via buttons.
The guide for the creation is here :https://www.youtube.com/watch?v=GnPuU3X74SY&t=264s
I also created an example for you, the pbix is attached.
Note that there is 2 sheets :
1 . Showing how it works2. with all visuals visible to let you follow the settings that I created :
You need the same interaction format between 2 tables :More information about interactions is here :
https://www.youtube.com/watch?v=MW_VzfNRzxg
And you need to switch off the V from data at the bookmarks :
More information about this is here :
https://www.youtube.com/watch?v=mLs1YuIkqls&t=44s
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
