Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Filters need to have a sync option just like slicers so that we could sync it in multiple pages.
@Anonymous
There is a workaround, albeit not as simple as your suggestion. You can use the sync slicers option and keep the slicers hidden in all tables.
Proud to be a Super User!
Paul on Linkedin.
@PaulDBrown: Thanks for your suggestion. We already tried with Slicers and to sync it in multiple pages. But the problem is that the date selection has to be an Advanced Filtering filter in the Filter pane. So the slicer and the filter was not getting sync as and when the date is changed in any of the pages. The slicer value might be changed according to the date filter selection, but as the date filter is applied as 'Filter on this page' it wont be getting sync.
Hi @Anonymous,
You can drag the column to "Filters on all pages" section within the Filter pane and set desired filter condition. This condition will be applied to all report pages within this report.
Reference:
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-filters-and-highlighting
https://docs.microsoft.com/en-us/power-bi/power-bi-report-filter
Best Regards,
Qiuyun Yu
@v-qiuyu-msft : Thanks for your reply.
Yes We do have the Filter on all Pages , and Filter on a visual. But my requirement is to apply to a report with 3 pages and apply this filter to 2 pages in the report and not to apply in one page
@Anonymous Use the 'Filter On This Page' feature. That way u can save multiple filters across pages.
@Arjun_SPThanks for your reply. 'Filter on this page' option wont be sufficient as the filter has to be sync across multiple pages and it is not required to be applied on a single page in the entire report.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |