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
KHorseman Super Contributor
Super Contributor

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.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!

View solution in original post

7 REPLIES 7
KHorseman Super Contributor
Super Contributor

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.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!

View solution in original post

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],
	", "
)
)
Highlighted
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.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 113 members 1,412 guests
Please welcome our newest community members: