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.
I have a page level filter calls department. I can filter my report by department. So when I filter by department A, I can see that the report only shows department A. But when I pin the report to dashboard, it seems like the filter effect is gone, all department data are shown. How can I create a dashboard that shows only the page level filter value?
I think the only way possible is to apply the filter and then pin individual objects as tiles in your dashboard. The objects preserve the filtering applied when pinned.
There a few problems with just pinning the individual objects to the dashboard:
1. The objects lost the interaction rules, for example, when I click on a sub-dept chart, the pie chart will show only the customers relevant to this sub-dept in my report, but the individual objects in the dashboard are "dead", they dont interact
2. I have a few slicers in the report and I would like to bring over to the dashboard, for example, the sub-dept slicer, the period slicer, etc, so that the dashboard users have richer experience in interacting with the charts. Pinning individual objects cannot bring over the slicer and the slicer interactions
It is ashamed that the dashboard does not carry over the page filter conditions. The only solution seems to be:
1. Use Power Query to restrict the data to each department and create for each department a separate pbix file
2. Publish each file to the PowerBI service and now you have for each department 1 report
3. Then pin the report page to dashboard, because each report only contain data of 1 department, it works around the problem of not having a page filter
The problem with this approach is when I have N departments, I have to split N pbix files. Once the master report template changes, it is painful to repeat the file split.
Hopefully someone can provide a better workaround of using only 1 report file.
Have you considered using SSAS with differrent roles for each department?
(and according to my experience, the dashboard tile does carry the page level filter and all filters aplied when the tile was created, which in many cases is a problem for me)
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.