Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Still working out my "newb" kinks in my early exposure to BI. Hoping someone from the group can help me with the following questions:
1. What is the difference between Page Level Filters vs. Report Level Filters?
2. If I can include Report Level Filters making them available to consumers of the reports I create, can they change multiple tabes in the workbook? i.e. A lot of reports are done by Market. Can I enable "Market" as a Page Level Filter, allowing all of the dashboards to reflect data for Detroit when this is selecte dby a user?
3. Are filters somehow an alternative for Slicers which don't work across multuple tabs?
Thanks.
1. Page level only impacts the page, Report level impacts all pages in the report. Think worksheets and workbook analogy in Excel.
2. You would use Slicers for this. You would have a report (with appropriate relationships in the data model) with various visuals, and a slicer for Market could be manipulated by the end users to view data filtered for the Slicer they select.
3. Filters are a more cumbersome way to dynamically filter data compared to slicers. Filters are great for removing entire subsections of the data, i.e. only showing data for the past year. Also, it is possible that the end user consuming the report via powerbi.com will not have access to the report/page level filters pane when viewing the reports, so if you want them to have interactivity with the data, go with slicers.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |