Mogli
Mogli

Reputation: 2012

How to clear all selections in PowerBI?

In Qlikview we have clear all option to clear all the selections, what is the similar option in PowerBI?

Even Refreshing the report(using Refresh button in Home) doesn't work.

I read somewhere that refreshing the browser(in case of web) can clear all selections and restore the previous stage but it's not a feasible solution. Is there any alternate of it ?

Upvotes: 3

Views: 20123

Answers (2)

StelioK
StelioK

Reputation: 1781

This can be accomplished by doing the following:

  1. Create a bookmark with your default slicer selections
  2. Ensure that "Display" is unchecked on the bookmark options
  3. Upload an image that will serve as your refresh/clear-all button
  4. Link the image to the book mark

Voila! Clear-all achieved

Upvotes: 7

Leonard
Leonard

Reputation: 2578

There is no one-click button that will clear all slicer selections on an existing report.

As you've indicated in your question, you can do a browser refresh and the report will be reset back to its default state. You can also click away from the report and go back in, and the report will be reset back to its default state.

The "Refresh" button at the top of the report gets the latest data but does not reset the report back to its default state. Switching tabs within the report also does not reset the report back to its default state.

While this isn't the answer you want to hear, there are a couple of ideas I'd encourage you to comment & vote upon. I know Microsoft do pay close attention to submitted ideas:

  1. Clear All Slicers
  2. Add Clear All Filters button to Power View**

** While the idea specifically mentions Power View, it's clear from the comments that the same request applies to Power BI, the successor to Power View.

Upvotes: 1

Related Questions