Forum Discussion
Helper IRelations 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.
Hi Stelian
I tried to test the question you asked, but due to lack of more information I can't help you in more detail.
If you can, please provide some dummy data. It would be best to provide pbix files and be careful to remove sensitive data.
Regards,
Nono Chen
StelianHello,
I've tried to uplod a file but ...
Anyway, for example, we have the following data from the source file:
Markets Companies Values A A1 5 A A2 7 A A3 8 B B1 4 B B2 6 B B3 7 C C1 2 C C2 1 C C3 3 If I select market A and companies A1 and A2:
Then, if I select market B without deselecting companies A1 and A2, there will be no values shown, as those companies remain selected.
If I deselect the A1 and A2 companies and select market B, the table will include values for the companies in market B.
However, if companies A1 and A2 are selected and I choose market B, the other companies from different markets should be deselected automatically, and only the values for companies in market B should appear in the table.
Thank you,
Stelian
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.