Forum Discussion
Filter One Dashboard from Another Dashboard
- 2 years ago
If you are really talking about Power BI Dashboards, ie collection of tiles, then i dont think you can do that.
But if you are actually referring to Power BI Reports, the only option that im aware of to transfer a selection (filter context) from one report to another is currently by using cross-report drillthrough
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through - Anonymous2 years ago
Hi AllianceDA ,
Thanks for Tutu_in_YYC reply, that's really helpful!
AllianceDA Based on my tests, PowerBI does not allow queries from one dashboard to affect the other because each sends a different query to the data source. One way I can think of is to create a main menu interface that customers can only switch to if they are authorized to do so. In addition, using a Row-level Security for data, customers can only see the records that are relevant to them.
Different pages for managers and customers: Customer can only select customer page and navigate to customer page.
Links about Page Level Security:
Page-Level Security workaround in Power BI - RADACAD
Applying Page Level Security in Power BI - ClearPeaks Blog
Links about Row-level security.
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
Best regards,
Mengmeng Li
If you are really talking about Power BI Dashboards, ie collection of tiles, then i dont think you can do that.
But if you are actually referring to Power BI Reports, the only option that im aware of to transfer a selection (filter context) from one report to another is currently by using cross-report drillthrough
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through