Forum Discussion
how to create a filter for table visuals
Visual level/page level filter is i am aware. but i dont want to do that, as i want to keep the table as it is and allow users to filter from the slicer
is there anyway i can do that as slicer? (Note: data is coming from 2 different table and they are connected via Many to many relationship)
i tried creating and measure and reaslised that measure cannot be added to slicer
hi vjnvinod
If so, I would suggest you try this way to get it as below:
Use bookmark and set two bookmark botton as a "slicer", and set different visual level filter for two table visual.
see more details by these document:
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Regards,
Lin
- vjnvinod6 years agoImpactful Individual
- v-lili6-msft6 years agoCommunity Support
hi vjnvinod
If so, you could refer to this blog:
Dynamically change the information within a visual via a slicer
Create two group measure which add conditional into measure, then use slicer to switch them.
But for your case, I would suggest you use bookmark, that is more simple.
Regards,
Lin