cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MojoGene Member
Member

Clear All Slicers On Page?

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Clear All Slicers On Page?

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.

7 REPLIES 7
Super User
Super User

Re: Clear All Slicers On Page?

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 Member
Member

Re: Clear All Slicers On Page?

Thanks. Sounds like such a simple thing.

djnww Established Member
Established Member

Re: Clear All Slicers On Page?

Agree. There is no such functionality.

prokurors Regular Visitor
Regular Visitor

Re: Clear All Slicers On Page?

Only thing this measure should be written slightly differently:

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

Re: Clear All Slicers On Page?

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 Frequent Visitor
Frequent Visitor

Re: Clear All Slicers On Page?

hi @xlnerdy , 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 ?

xlnerdy Regular Visitor
Regular Visitor

Re: Clear All Slicers On Page?

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.