Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Shwartzman
Frequent Visitor

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

2 ACCEPTED SOLUTIONS
pankajnamekar25
Super User
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 | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

View solution in original post

MattiaFratello
Super User
Super User

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

View solution in original post

8 REPLIES 8
MattiaFratello
Super User
Super User

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

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

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!



Hi @Shwartzman ,


Has your issue been resolved? If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.

If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!

Hi @Shwartzman 

If the information posted by us 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.

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.

pankajnamekar25
Super User
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 | LinkedIn

If 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?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors