Forum Discussion
Impactful Individualhow to create a filter for table visuals
Community SupportHI vjnvinod
Just set visual level filter for 'TMT Master NEW'[Latest Market Value (US$)] is greater than 1000000000 and Account_Listing[TER_FYTD_USD ] is less or equal to 100000.
https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter#add-a-filter-to-a-visual
If not your case, please share a simple sample pbix file and your expected output.
Regards,
Lin
Impactful Individual
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
- v-lili6-msft
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
- vjnvinod
- v-lili6-msft
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