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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Multi select slicer

Hi Everyone,

 

I have a slicer in which i have "select all" option and i want to show two other option appliying visual level filtered from the slicer values.

 

Example :

avinash176_0-1703608527477.png

Scenario is :-

When user is selecting select all option the two other two option(Compliance and Premier) which i have provide should be excluded.

But he can select the other two option avaliable individually as an example if he select compliance than he will see filterd value of compliance only.

 

can ayone help me to achieve this @Ahmedx , @amitchandak@Ritaf1983 , @Fowmy , @lbendlin  .

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi All, 
I got the working solution for this requirement instead of having select all slicer and filter option, i have calculated a table wherein i have two other option which i wanted and the rest is select all with the swtich statement.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi All, 
I got the working solution for this requirement instead of having select all slicer and filter option, i have calculated a table wherein i have two other option which i wanted and the rest is select all with the swtich statement.

lbendlin
Super User
Super User

When user is selecting select all option the two other two option(Compliance and Premier) which i have provide should be excluded

No, "Select All"  literally means "select all". Meaning "include all".

Keep in mind that "Select none"  is the same as "Select All"  in Power BI world. 

Anonymous
Not applicable

Can you give me other way around to give user an option to do the following.
1. Select All ( he should be able to select all option excluding the other two option)
2. Select one option which in our case is suppose "Compliance"
3. Select one option which in our case is suppose "Premier"

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors