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! Learn more

Reply
Wei2
Helper I
Helper I

single selection in slicer

I have multiple slicers in a report.  I want to make "Region" slicer as a single selection, "Name" slicer as a single selection and "Product" slicer as a multple selections.   When I select a "ANZ" from the Region slicer and pick a "John" from the "Name" slicer and then choose multiple products in the "Product" slicer.   However how I can go back to "Region" slicer to choose a different region (lets say "Southeast Asia"  from the Region slicer and pick a different sales name and products for my next search?  

1 ACCEPTED SOLUTION
MahyarTF
Memorable Member
Memorable Member

Hi,

As I understand, you have multi-table, with the relation between those,

So when you select a(more) value in one slicer, it means you restricted other related table(s).

you select the Name, so you choose the child's one in your model, then if you want to choose another value, you need to clear the slicer, then choose the new search. 

it is my opinion, not sure if it is useful

MahyarTF_0-1658824030081.png

Mahyartf

View solution in original post

9 REPLIES 9
Anonymous
Not applicable

If you always want to filter by starting from Region then: select Product slicer, go to Format > Edit interactions and disable filtering on Region slicer, similar thing with Name (Format > Edit interactions and disable filtering for region). This should do the trick. 

Thanks.  How come my region doesn't show the icon which can allow me to disable filtering?  But I can see other filter having the disable icon? 

Wei2_0-1658833494425.png

 

 

Anonymous
Not applicable

If region slicer  is selected then the icons won't show, but will show on other slicers.

You select the slicer that should not filter other slicers "If I select something on Product slicer I don't want Region slicer to be filtered" so you select Product slicer end disable filtering on region slicer because you dont want product slicer to interact with region slicer.

 

Slicers in Power BI - Power BI | Microsoft Docs

Thank you. 

BTW,  I just found out a wierd thing.  I disabled filtering the Region slicer.  Then I select a region from Region slicer and select a sales name from the "Account owner" slicer.  Then I go back to region to select a different region and the sales name that I chose earlier for the region will also show with all other sales names for another Region that I'm going to re-select.  

For example:  I selected Japan first and then selected a sales name "Mami".  Now I'd like to select a different country - "Korea" but Mami who is Japan's sales also show up with the other 2 Korean sales names?  But I only want David and John who are Korean sales show up when I select Korea from the Region slicer.  

Wei2_1-1658877794005.png

 

 

Have you found a solution to this problem? I am also facing the same.

Anonymous
Not applicable

It works this way - for single selection it always have to be selected something and PBI keeps the lastest selected item

Wei2
Helper I
Helper I

But after I change to single selection, I don't see this icon for me to clear selections.

Wei2_0-1658829298482.png

If I change to multiple selections, I can see clear selections.  

So there is no way for me to show all items after I click on one radio button?

Wei2_1-1658829414260.png

 

 

MahyarTF
Memorable Member
Memorable Member

Hi,

As I understand, you have multi-table, with the relation between those,

So when you select a(more) value in one slicer, it means you restricted other related table(s).

you select the Name, so you choose the child's one in your model, then if you want to choose another value, you need to clear the slicer, then choose the new search. 

it is my opinion, not sure if it is useful

MahyarTF_0-1658824030081.png

Mahyartf

Helpful resources

Announcements
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!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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