How to remove Power BI filters in two easy steps

December 2022 · 2 minute read
how to remove Power BI filters

XINSTALL BY CLICKING THE DOWNLOAD FILE

To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:
  • Download DriverFix (verified download file).
  • Click Start Scan to find all problematic drivers.
  • Click Update Drivers to get new versions and avoid system malfunctionings.
  • Users have reported that there is no built-in option for removing filters when using Power BI, and this makes it difficult to navigate, especially in very extensive files with 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

  • Make sure all of your filters are clear before starting
  • Create a bookmark of your current screen and name it Clear Filters
  • Link the bookmark to the page
  • Select Home
  • Click Image, and upload a picture that will be representative to your task
  • Place it in an area on your worksheet
  • Name it Clear Filters
  • Link the image to the bookmark you’ve previously created
  • Perform whatever tasks you want, and press this custom button to clear all of your filters
  • You will basically be creating a “restore point” for your Power BI file. Thus, pressing the button you’ve just created will simply make the file go 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 different Power BI file that share this issue.

    ncG1vNJzZmivmaOxsMPSq5ypp6Kpe6S7zGipnqWfq7JuvM6wnKtlkp56p7XLrZyrq18%3D