Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I have data where there are no of PM having multiple Project ID's.
I have created a report with RLS and shared with everyone who is there in PM list.
But here each pm having more than 2 projects.
So for selection of projects i have used chicklet slicer, so that user can easily select a project and see the visuals.
But here we didnt choose any project so all the charts and cards will be of cumulative values of all the projects, which gives a wrong impression to the user.
So what i did is, i have choosen forced single selection in slicer options so that all the charts and cards will be discussing about only that single project.
But after pubishing this report to the service and sharing it with the respected PM's,
here the user who is having that auto selected project id will be able to see the complete dashboard or report.
But the rest of the PM's wont, all the charts and cards are showing blanks and even there are no projects in the slicer list.
Is there any better way to do this.
Any suggestions.
Mohan V
@Anonymous
I haven't reproduced your issue. I created a report with RLS configured and force single selection set on Chiclet slicer. The users I shared with can only view their own data.
I think the issue might be your row level filter, please remove the Chiclet slicer to see if the RLS works for those "shared with" users. If not, please verify your row level filter expressions.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |