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
Phamacom Just to double-check, when you say "dashboard" do you really mean a Power BI dashboard or are you referring to a report? Dashboards are specific things in Power BI and a lot of people coming from other technologies use the word dashboard when they are really referring to a report. If it is actually a report that you want for each attorney then I would recommend RLS (row level security).
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