Forum Discussion
Dashboard Design
Hi Phamacom,
#1, You can design a report and setting RLS filter based on username to achieve current user filter effects on the report and assign this role on power bi service side to your members. (notice: RLS filter only work with read permission users, you need to configure your users' permissions on the dataset side)
Solved: RLS with UserName() - Microsoft Power BI Community
Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
#2, I'd like to suggest you check the following blog about dynamic attribute filter if it is suitable for your requirement:
Dynamic Attributes In A Power BI Report | P3 Adaptive
Regards,Xiaoxin Sheng
Greg,
I don't mean a report but a dashboard. The dashboard gives the user ability to change the info based on the slicer selection. The slicer lets them see current month, last month, and YTD information.
Rob
Hi Phamacom,
#1, You can design a report and setting RLS filter based on username to achieve current user filter effects on the report and assign this role on power bi service side to your members. (notice: RLS filter only work with read permission users, you need to configure your users' permissions on the dataset side)
Solved: RLS with UserName() - Microsoft Power BI Community
Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
#2, I'd like to suggest you check the following blog about dynamic attribute filter if it is suitable for your requirement:
Dynamic Attributes In A Power BI Report | P3 Adaptive
Regards,
Xiaoxin Sheng