Forum Discussion
Create Filtered Dashboards without Showing the filter
I have a report (pbix) which include around 30 pages. I published this report and created a dashboard which I can call it Global Dashboard and share this dashboard with relevent peoples.
Now I wanna create the same dashboard again but with filtered data and share with relevent stakeholders. So, each stakeholder should only have permission to view his data.
For example, I have a report with all department data. I have created a dashboard with all department data and shared with relevant peoples. Now, Department A (let's say) also wanna see same dashboard but filtered with Department A data. Similarly, Department B wanna his own dashboard with thier data and so on.
Do I need to create seprate reports (or pages) for each depertment that filter thier data and then create dashboard from this or there is any easy way?
Hi iqb,
You need to implement Row Level Security in your reports. Creating multiple dashboards with filters is not the best possible solution. Here's a link for your reference:
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Did I answer your question? Mark this post as a solution if I did!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI
1 Reply
Hi iqb,
You need to implement Row Level Security in your reports. Creating multiple dashboards with filters is not the best possible solution. Here's a link for your reference:
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Did I answer your question? Mark this post as a solution if I did!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI