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.
Hi,
I have multiple reports with each reports having two slicers named as the category & Items and all the tables in the data model has the column named as Category. Each report has been bookmarked and linked to a button so that the user can Navigate between the reports.
Currently, I am applying RLS on each report by creating a role for each category. The issue is that I have set up some default value in each slicer in report & created a bookmark for that and linked that to the Buttons.
After applying the RLS to all reports, my both slicers present in each report has the same default value selected as before. My requirement is that Category slicer should have the value selected dependent on the Category Role.
For example, If I have a role Named as category 1, then the Category slicer should have the value selected as Category 1 in all Bookmarked page, If I have a role as category 1, then the category slicer should have the value selected as category 2 in all bookmarked pages. I am not sure how to proceed on this.
Solved! Go to Solution.
Hi @Amir851
As far as I know, there is no elegant way.You may vote this similar idea which has been submitted and add your comments there to improve Power BI and make this feature coming sooner.
Regards,
Hi @Amir851
As far as I know, there is no elegant way.You may vote this similar idea which has been submitted and add your comments there to improve Power BI and make this feature coming sooner.
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 |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |