Forum Discussion
Dynamically filter a slicer based on another visual
Hi Everyone,
I wanted to check if it's possible to dynamically filter slicer menus based on selecting a specific bar in a bar chart.
Typically, selecting a slicer value filters the visuals. But can the opposite happen? For example, if I select a category in a bar chart, can the slicer values adjust accordingly?
I've tried looking through the questions already asked to see if anyone has come across the subject before, but I haven't found an answer that would solve the problem.
I would be grateful if you could provide a simple, concrete example to support your answer.
Thank you in advance for your help and time!
EgksThe Old slicer will not get filtered based on visual selection but you can use new slicer visual instead.
Old slicer interaction:
New Slicer Interaction:
Did I answer your question ? If yes, please mark this post as a solution.
Thanks,
Jai
6 Replies
EgksThe Old slicer will not get filtered based on visual selection but you can use new slicer visual instead.
Old slicer interaction:
New Slicer Interaction:
Did I answer your question ? If yes, please mark this post as a solution.
Thanks,
Jai
Many thanks for you quick reply and response Jai-Rathinavel 😁
Finally! The answer was there right in front of me - the new style slicer visual! I had tried every conceivable way of getting the old slicer to filter when I selected a bar on my visual. Seems like all the advice on the web relates to the old slicer visual. Many thanks Jai! Pity the new visual does not behave like the old one!
Jai-Rathinavel Could you please confirm for me that the vertical list slicer display format that you have with the old slicer in the capture is not available in the new one? We can only have thicker rectangles in the new one and not the dropdown menu or vertical list?
Egks Unfortunately we don't have dropdown slicers in new slicer visual. But you can mimic a list my setting your layout as single column with multiple rows. You can use bookmarks to make a dropdown experience.
Thank you for your prompt feedback ! Jai-Rathinavel
