Forum Discussion
Multiple Company Selection in Different Slicers
Please try these steps for the first part of your question and let me know if it still does not work. Also, make sure to keep a backup of your file.
I created it this way:
Step: Please check whether your model is similar to this.
Next step is to do bookmarks, as you already have everything:
and for each of these set the show hide accordingly. Say, like these for the 1, 2, 3 ...
, ,
Go through each bookmark, right click, uncheck the data:
You can give bookmark names of your choice.
Test: click on these buttons after configuring the actions and they should work.
All three should work i.e., based on the (black) buttons, the charts display accordingly.
------- by now all 3 bookmarks functionality should be working -------------------
Let’s look at the slicers next.
- From the 3rd page, which is the dashboard, select the first slicer that is linked to the Comparison1 table column. Give it a name so we can reference it later. Copy it.
- Go to page 2 and page 1, paste it. This will ask you whether you want to sync slicers or not. Say yes.
- Select the slicer using the Description Table in Page 1. In the sync slicers, in the advanced options, use the slicer name used for the first slicer in the 3rd page. Similarly, do the same step in Page 2.
- Now, hide this newly copied slicer in page 2 and page 1.
- It should work. Please check this video, and this is what you need in my view.
https://www.youtube.com/watch?v=jKOjXPkXO8U
Super UserRegarding (1) i.e., sync of slicers, did you try this?
Note: The use of sync slicers must be on same fields of the same table.
Based on your post, you did all major work and just misisng the sync slicers. hence provided the link.
Hi,
Yes, i'm using synch slicer for pages 1 and 2. I could do the same for comparison page, but if i use a slicer with the same field of the same table that i use in slicers in company 1 and 2, the features of the comparision pages breaks.
It's kind of a complex feature, hope someone can help me with that.
Thank you.
- sevenhills
Is it possible to share the .pbix file with some mockup data. and expected output, we can help.
Sync Slicers work only if you use the same column in each page for the slicer. However, it is not clear why it is not working when you use sync slicers and the same column. Additionally, you mentioned that the Description is linked to the Values table, so you cannot use multiple slicers logic. Could you please provide the DAX you used for the measure used to filter in the page/dashboard 3?
Tip: Avoid using the keywords of DAX or M query as your table names in the long term to avoid confusion.
Thanks
- sevenhills
Please try these steps for the first part of your question and let me know if it still does not work. Also, make sure to keep a backup of your file.
I created it this way:
Step: Please check whether your model is similar to this.
Next step is to do bookmarks, as you already have everything:
and for each of these set the show hide accordingly. Say, like these for the 1, 2, 3 ...
, ,
Go through each bookmark, right click, uncheck the data:
You can give bookmark names of your choice.
Test: click on these buttons after configuring the actions and they should work.
All three should work i.e., based on the (black) buttons, the charts display accordingly.
------- by now all 3 bookmarks functionality should be working -------------------
Let’s look at the slicers next.
- From the 3rd page, which is the dashboard, select the first slicer that is linked to the Comparison1 table column. Give it a name so we can reference it later. Copy it.
- Go to page 2 and page 1, paste it. This will ask you whether you want to sync slicers or not. Say yes.
- Select the slicer using the Description Table in Page 1. In the sync slicers, in the advanced options, use the slicer name used for the first slicer in the 3rd page. Similarly, do the same step in Page 2.
- Now, hide this newly copied slicer in page 2 and page 1.
- It should work. Please check this video, and this is what you need in my view.
https://www.youtube.com/watch?v=jKOjXPkXO8U
