Forum Discussion
Cannot Clear the Filter In PBI Desktop
Hi Everyone 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 ...
The way arround if there is no way to remove the filter:
1. Go through all visuals where the column is used and delete it from them (make a note where they were located on the list of Values on each visual.
2. Duplicate the page.
3. Add the column to the visuals you removed it from, delete the old page, rename new one with the old one name and refresh bookmarks related to that page if you have any, e.g. Reset.