Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
When we publish power bi report to Service, we have to make some dafault selection in slicer. After RLS, still that default selection comes.
Slicer selection can't be dynamic as per role they belong to ?
User | Product class |
Robin | A |
Robin | B |
Ryan | C |
If my default slicer is at A, but RLS say Ryan has logged in then it should be at C automatically in power bi service.
Note: Only one product class value should be selected as per the requirement. so the option of "ALL" is not available.
Thank you
Hi,
Is it possible picking a specific bookmark based on a RLS filtered value.
I recently faced this same problem. Since there is not possible One sorta workaround it is to add a dummy row of something along the lines "Choose a Product Class" and publish your report with that selected in the slicer.
Another way is to teach each user to create a personal bookmark.
Hi @YadavRo ,
It is a good idea, while this feature is not available in Power BI currently. Please review the following links, and check if the methods in them can be used as an workaround...
PowerBI Slicer Dynamic Default Value selection based on User Login
What you ask is not directly possible in Power BI, but you can achieve something similar using bookmarks. Leave the slicer in the report without any selection, then login as each user (or ask them to do it themselves) and create personal bookmark with the desired items selected for the current user, and make this bookmark to be the default view. Now, whenever the user return to the report, this will override the persistent filter state (specified by you in the report) and land him in the view specified by the bookmark.
How to set default value of single select slicer using rls
Customizing default values for each user in Power BI reports
In additon, you can submit a new idea. It is a place for customers provide feedback about Microsoft Office products . What's more, if feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best Regards
Hi,
Is it possible picking a specific bookmark based on a RLS fitered value.
No, that is not possible.
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |