Forum Discussion
Relations between slicers
Hi Stelian
Thanks for sharing the data!
Do you choose to keep the company slicer from affecting the market slicer?
You can view this by clicking on the company slicer, going to the FORMAT tab and selecting EDIT INTERACTIONS.
You can see two icons in the top right corner of visual, like this:
If you select the icon on the right, the situation you are experiencing will appear.
This is because the two slicers do not affect each other, but there is no information for A1 and A2 under Market B, so no data is displayed.
If it's not the above, I can offer other solutions as well.
You want to implement reselecting the slicer and the data is automatically reset, power bi doesn't seem to support this. However, you may consider using bookmarks and buttons. I have provided some steps to create them:
First, clear all your choices for the slicer.
Click on "View" in the tab and select "Bookmarks". Add the current page as a bookmark.
Click on "Insert" in the Options tab and select "Buttons".
Attach a bookmark to the button.
When you use the button (Ctrl + Click), then it returns to the slicer unselected state.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think you can't do that way. You can't deselect values on a filter.
I think what you should do is put everything on the same slicer, so you will have markets at first level and all the companies in that market as the second level. The user will be able to select wich companies and also combine companis from different markets and also know what market a company belongs too.
So in my opinion you should use only one slicer not 2
Thank you for your quick response. I need both slicers, so I'll wait, maybe a solution for this will arise.