Clear All Slicers On Page?

[MojoGene]

I am surprised I can't find an easy solution for this. I have many pages in my reports with multiple slicers. Is there a way to clear all slicers on a page with one click? This is critical for end users, who are sometimes (frequently?) unaware that the data are being sliced. 

I have found a measure to show exactly what items are selected, which is quite useful (can't recall who I copied this from):

Matter Selected = 
IF(NOT(ISFILTERED(Matter[Matter])),"All",
CONCATENATEX(
	ALLSELECTED(Matter[Matter]),
	Matter[Matter],
	", "
)
)

 But still, it seems like there must be a simple and straightforward solution to this problem.

[prokurors]

Only thing this measure should be written slightly differently:

MeasureName = 
IF(NOT(ISFILTERED(Table[Column]));"All";
CONCATENATEX(
	ALLSELECTED(Table[Column]);
	Table[Column],
	", "
)
)

[Anonymous]

There is a great workaround using Bookmarks feature, that I implemented recently. Bascially, you just have to create a bookmark, with you default filters (or default view, without any filters/slicers). Insert a shape on that tab, and assign this bookmark to this shape. No matter which filter (page slicers or report fitlers) is selected or enabled, Clicking on this shape will call the bookmark, which had no filters.

Let me know if this helps.

[abhinav_verma]

hi @Anonymous , bookmarch approach helps, but if i have role management included in my dashboard, my reports formatting gets drastically change after applying bookmark, be it clear all or more info type description functionality, have you or any one else faced the same issue ?

[Anonymous]

Hi @abhinav_verma thanks for sharing your experience. I believe I could track with you and can confirm that I have seen or experienced similar issues. Key is to update the bookmark, after every little change that you do to the view. let me know if that helps.

[Anonymous · Accepted solution]

In a published report, if you change report pages and come back, it will return to the default slicer selection from when you published it. Other than that there's no "clear all" function.

[MojoGene]

Thanks. Sounds like such a simple thing.

[djnww]

Agree. There is no such functionality.