Forum Discussion
Filtering Data
To retain selections across multiple visuals, hold down Ctrl when making each selection after the first.
In your example,
- Table 1: Click A1172
- Table 2: Ctrl-click SP12508
- Table 3: Now filtered by Customer Name = A1172 & Item = SP12508
Chris_68 Glad to hear it 🙂
As far as I know, selections on any non-slicer visuals (including table/matrix) are always cleared when making another selection without Ctrl.I believe the only solution would be to resort to slicer visuals of some sort. I mocked up an example of how it might work with Button slicers, just as an idea (attached).
You can play around with formatting, but I would prefer it if the values shown on the buttons could be placed to the right but don't think it's possible without concatenating the values via a measure.
BTW - I adjusted/added a few measures along the way, and some visual-level filters were required for the slicers.
Not sure if this would be suitable for you but might be worth trying 🙂
Hi Owen,
Glad to confirm it's working.
Is there a way to enable the function without requiring users to hold the Ctrl key? The file will be used by multiple people, and it's likely some may miss that step.
Appreciate your advice once again.
Chris_68 Glad to hear it 🙂
As far as I know, selections on any non-slicer visuals (including table/matrix) are always cleared when making another selection without Ctrl.
I believe the only solution would be to resort to slicer visuals of some sort. I mocked up an example of how it might work with Button slicers, just as an idea (attached).
You can play around with formatting, but I would prefer it if the values shown on the buttons could be placed to the right but don't think it's possible without concatenating the values via a measure.
BTW - I adjusted/added a few measures along the way, and some visual-level filters were required for the slicers.
Not sure if this would be suitable for you but might be worth trying 🙂
Hi Owen,
This is fantastic, thank you very much.
Have a great weekend!
Chris
Hi Owen,
Noticed that there is a measure Rank Owen 1, is this in use?Just another question, on the 2nd table visual, is it possible not change the item when making any selection? For example, when selecting SP12508, the items that were listed earlier will be changed.
Thank you.
ChrisHi again Chris,
Glad it's useful!
No, Rank Owen 1 isn't being used. I think I tested something out with that measure but didn't end up using it.
On the 2nd question, did you mean you don't want the 2nd table/slicer to filter the 1st table/slicer? On the Slicers page I created, I edited interactions so that the 2nd slicer doesn't filter the 1st slicer.
Let me know if you meant something else 🙂