Forum Discussion
Slicer settings based on the user type
I have a pbi dashboard with a slicer containing codes. If a "Normal" user is using the dashboard I want him to only be able to select one code at a time (single-select). But if an "Admin" user is using the dashboard I want him to be able to select any number of codes, including selecting all of them (multi-select with select all option).
How can I achieve that?
Thanks ahead!!
Edit: another alternative that can be accepted is to direct the user to a different page based on his type. Meaning that when a user is opening the dashboard he will be directed to page1 if he is an admin and to page2 if he is not
Hello Shwartzman
Create Two report page and configure
Page 1 (Normal User Page): Add the slicer and set it to Single-Select mode.
Page 2 (Admin Page): Add the same slicer, but leave it in Multi-Select mode with “Select All” enabled.
)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hi Shwartzman,
you could try to user bookmarks to redirect admins to a page with a multi-select slicer while redirect normal users to a page with a single-select slicer
8 Replies
- pankajnamekar25
Super User
Hello Shwartzman
Create Two report page and configure
Page 1 (Normal User Page): Add the slicer and set it to Single-Select mode.
Page 2 (Admin Page): Add the same slicer, but leave it in Multi-Select mode with “Select All” enabled.
)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Its also an option.
The thing is that my dashboard is for both of them. So there is one dashboard with multiple permission values. How can i redirect the admin to their corresponding page?
- MattiaFratello
Hi Shwartzman,
you could try to user bookmarks to redirect admins to a page with a multi-select slicer while redirect normal users to a page with a single-select slicer
v-aatheequeCommunity Support
Hi Shwartzman ,
If the information posted by MattiaFratello pankajnamekar25 is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help you.
We value your feedback, and it will help us to assist others who might have a similar query.Thank you for your contribution in enhancing Microsoft Fabric Community Forum.
I have one dashboard for both permission values. How can i make so one permission cannot see the other's option. Foe example i dont want to have a page with two buttons that each is active only if you have the corresponding permission. i would like to have a page where only one button is visible at a time ans that button will redirect you the bookmark/page that is for you
- v-aatheeque
Hi Shwartzman ,
Unforutnatley ,Power BI does not support dynamically changing slicer settings (like single-select vs multi-select) based on user type directly.If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!