Forum Discussion
planzel
10 years agoRegular Visitor
Issue when switching pages for report level filters
When we apply a report level filter on a report page, then switch to another page in the report, it appears that the filter is not applied. The report level filter remains checked but it takes a cli...
ankitpatira
Community Champion
10 years agoplanzel I replicated your scenario by using directquery to sql server and then published the report. In powerbi.com I edited report and added report level filter. I didn't see any issues and it did filtered all the pages in my report.
Below is my guess about what might be happening in your case.
1) Since you're using DirectQuery it actually connects on-prem and filters data therefore you need to wait a little for pages to be filtered. Look for dotted spining circle.
2) Ensure your tables on-prem are connected therefore when you apply filter to one page data represented on second page has relationships that will fitler it.
3) Switch to import if can.
Do let me know if any of above works for you.