How to deselect visual table rows with a button

[ImaKickUrBut]

Hello!

I have a couple of cross-sliced table visuals with a medium amout of rows and my users are getting confused about why the "Clear All Filters" button clears slicers but doesn't de-select table rows. They don't always realize when they have a row selected, so they submit trouble tickets because they can't find the additional related rows and think there's data missing, but they just need to scroll to & deselect a table row.

Is there a way to deselect table visual rows with a button? or is there another on-page approach to reset tables to their un-selected state?

Thanks in advance!!

[danextian · Accepted solution]

Hi @ImaKickUrBut 

You can bookmark the deselected state of a visual.  For it to go back to the deselected date, Data option must be checked which also means that if a visual filter is applied to the viz, it will go back to the state prior to applying the visual filter.

Another option is, of course, to educate your user through training or by adding a guide somewhere in the report.

[ImaKickUrBut]

Thank you @danextian! this solves my table record de-selecting issue.
Is there a way to clear all slicers AND delselect the table visual records? the bookmark resets all the slicers & sets the visuals back to their original state for the most part, but a user typed some letters in a slicer search dropdown & bookmark does not clear that text, but clicking a 'clear all slicers' action button does. is it possible to add both bookmark & clear all slicers actions to a button?

[FreemanZ]

hi @ImaKickUrBut ,

check this:

https://learn.microsoft.com/en-us/power-bi/create-reports/buttons-apply-all-clear-all-slicers?tabs=p...

[ImaKickUrBut]

Hi @FreemanZ ,

thanks, I have a 'clear all slicers' (labeled clear all filters) button but it doesn't deselect table rows. 

Is there a potential solution with bookmarks mentioned in the https://learn.microsoft.com/en-us/power-bi/create-reports/buttons-apply-all-clear-all-slicers?tabs=p... article? I haven't used the bookmarks feature yet!