Forum Discussion
Variables in a Slicer not showing for some users
Good morning--hopefully a simple question!!
I have a report that contains a Slicer that has optiosn for MB, SB, ENT, Other
I have published this to my workspace and updated my app.
When i open the app i can see all options under the slicer but some of my users can only see ENT on one tab but can see all options in another tab.
i have asked them to clear their cache, close all open PBI reports then reopen but still the ssame issue occurs
Any ideas?
Greg
Hi GREGBLACK,
Thank you for reaching out to Microsoft Fabric Community.
Since RLS only applies to country and not segment, the issue might be caused by:
- Power BI remembers user selections even after updates, so ask the users to click Reset to Default in power bi service to clear any cached settings and see the latest version.
- Even if segment-related filters were removed, a hidden page-level or report-level filter might still be affecting the Detail tab. Check the Filter Pane for any active filters and confirm that no filters are applied at the visual level in the Detail tab.
- Manually refresh the dataset and republish the report to remove any old cached versions. And ask the affected users to clear their browser cache and sign out/sign in to Power BI Service.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
3 Replies
- Akash_Varuna
Super User
Hi GREGBLACK This issue might be caused by row-level security (RLS) or differences in data permissions for the affected users. RLS may restrict slicer options based on user access. Verify if RLS or permissions are applied to the dataset and ensure they align with the users’ roles. If no RLS is set, check for any inconsistencies in data or filters applied at the report or slicer level.
I this post helped please do give a kudos and accept this as a solution
Thanks In Advance i do have RLS on but only for Country not segment which this slicer controls
i did think it was RLS related but what is strange is the following:
2 weeks ago when i first created the report my stakeholder only wnated to see Ent so I filtered out MB and SB
then they wanted MB as well as ENT so i allowed for MB and ENT in the filter--after publishing they could still only see ENT so i took off all segment related filetrs so they could see MB,SB and ENT, whcih after publishing they could
yesterday in a summary tab they can see all but on a detailtab they can still only see ENT
v-achippaCommunity Support
Hi GREGBLACK,
Thank you for reaching out to Microsoft Fabric Community.
Since RLS only applies to country and not segment, the issue might be caused by:
- Power BI remembers user selections even after updates, so ask the users to click Reset to Default in power bi service to clear any cached settings and see the latest version.
- Even if segment-related filters were removed, a hidden page-level or report-level filter might still be affecting the Detail tab. Check the Filter Pane for any active filters and confirm that no filters are applied at the visual level in the Detail tab.
- Manually refresh the dataset and republish the report to remove any old cached versions. And ask the affected users to clear their browser cache and sign out/sign in to Power BI Service.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
