I have a report based on RLS with two slicers one Department and second Jobs
Users can see only jobs which they belong to theirs department.
Everything works just fine (for example user A can see jobs belong to Dept 10 and user B can see jobs belong to dept 11)
The problem start when I modify the Job slicer to single select for example if I publish the report I need to select at least one job which belong to department that only users with RLS can see.
For example I published a report with Department = ALL and Job 10
When user B try to browse the report he / she see an empty report because theris department is not on theirs RLS list.
My question - how do I reset the single select slicer so on the first time user can see theris department and jobs?
Solved! Go to Solution.
There is no such feature in current version of Power BI.
Here are some workarounds:
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your response but it not solve my issue.
Single select slicer can't start on load page event with null value like programming language (radio button for example)
It has to fix with Microsoft development team. (maybe in a few months)
How to I close this incident without having to mark it as solved?
@Anonymous solution I proposed will need some development which I will as part of my experiment. It is great request and need to be fixed.
@Anonymous I see what you are saying, it is going to be a problem because when you set a single slier, it selects a value. In this case you need to add a value in slicer table called "All" which should be selected as a default and when users are switched, by default "ALL" is selected since it will be available for every user regardless what department data they can see. I don't see any other workaround for now.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.