Forum Discussion
Drill through and filter
There is a drill though between the summary dashboard and the supplier dashboard which also has a filter, let's say I'm drilling through supplier A, when moving to the supplier dashboard the supplier filter only shows supplier A, which make sense but I want to give the end-user the option to move through dashboards and use the filter. Is there a way to do this? I think bookmarks will do but I have 5 filters on the main dashboard so I need to make a lot of bookmarks right?
HI NoorAlfar,
It seems like you want to add an additional filter based on the current user.
For this scenario, I'd like to suggest you create the username and supplier mapping on the target report user table and enable the RLS based on username.Solved: RLS with UserName() - Microsoft Power BI Community
After you configure RLS and assign roles on the power bi services side, the user who drills through the target report will also be filtered by the current username.Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
Regards,Xiaoxin Sheng
1 Reply
HI NoorAlfar,
It seems like you want to add an additional filter based on the current user.
For this scenario, I'd like to suggest you create the username and supplier mapping on the target report user table and enable the RLS based on username.Solved: RLS with UserName() - Microsoft Power BI Community
After you configure RLS and assign roles on the power bi services side, the user who drills through the target report will also be filtered by the current username.Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
Regards,Xiaoxin Sheng