Share this article

Improve this guide

How to remove Power BI filters in two easy steps

2 min. read

Updated onOctober 4, 2023

updated onOctober 4, 2023

Share this article

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Users have reported that there is no built-in option for removing filters when usingPower BI, and this makes it difficult to navigate, especially in very extensivefileswith tens or maybe even hundreds of filters.

My report has 12,541 rows and one of the applied filters on the report has filtered it down to 19 rows, now I want to get my report back to its original position ie; 12,541 rows.I have tried many ways to clear the filter which I applied previously while working on the report. I have tried all possible ways to clear it however, the report isn’t removing the applied filter.

Steps to remove Power BI filters

1. Restart Power BI

Some users confirmed that restarting Power BiI fixed the problem. So, if you haven’t tried this solution yet, please do so as this may quickly fix your problem. If the issue persists, go to the next solution.

2. Create a custom “Removes Filter” button using Bookmarks

You will basically be creating a “restore point” for yourPower BIfile. Thus, pressing the button you’ve just created will simply make thefilego back to the previous state it was in, when no filter was applied.

Note:This can be considered more of a workaround, and you will have to repeat the process for each differentPower BIfilethat share this issue.

Teodor Nechita

Eager to help those in need, Teodor writes articles daily on subjects regarding Windows, Xbox, and all things tech-related.

When not working, you may usually find him either at the gym or taking a stroll in the park, trying to find inspiration for the next articles he may write.

User forum

0 messages

Sort by:LatestOldestMost Votes

Comment*

Name*

Email*

Commenting as.Not you?

Save information for future comments

Comment

Δ

Teodor Nechita