Reply
Member
Posts: 123
Registered: ‎05-01-2016
Accepted Solution

Clear All Slicers On Page?

[ Edited ]

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.


Accepted Solutions
Super User
Posts: 1,183
Registered: ‎12-29-2015

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.

View solution in original post


All Replies
Super User
Posts: 1,183
Registered: ‎12-29-2015

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.

Member
Posts: 123
Registered: ‎05-01-2016

Re: Clear All Slicers On Page?

Thanks. Sounds like such a simple thing.

Established Member
Posts: 221
Registered: ‎09-09-2015

Re: Clear All Slicers On Page?

Agree. There is no such functionality.

Regular Visitor
Posts: 49
Registered: ‎12-15-2015

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],
	", "
)
)
Highlighted
Regular Visitor
Posts: 29
Registered: ‎06-05-2017

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.

Frequent Visitor
Posts: 3
Registered: ‎04-11-2018

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 ?

Regular Visitor
Posts: 29
Registered: ‎06-05-2017

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.