Forum Discussion
Helper IDrill through and filter
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
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