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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Michaela_Onu
Microsoft Employee
Microsoft Employee

Slicer incorrectly chooses both filter fields

Hi all, 

I have a problem with my Hierarchy slicer. I have triple-checked the mapping and it's 100 % correct, all the other Hierarchy slicers work fine. This one, however, ticks both categories even though I tick only one. 

Imagine I have two options, A and B. Under A, there is A1 and A2, under B, there is B1 and B2. If I want to tick A, both A and B get selected automatically. If I tick B, only B gets selected. I have disabled single selection and if I unselect B, only A is showing as desired. But when the filter is empty and I want to click A, B gets selected as well. I tried ticking the subcategories and they work fine - if I start by ticking A1 and A2, I only get A selected, same goes for B subcategories. 

Does anyone have any idea as to what is causing this issue? 

Thank you. 

TL;DR: If I tick A, both categories get selected (as illustrated in the picture), mapping is correct. 
Hierarchy slicer.png

1 ACCEPTED SOLUTION
Michaela_Onu
Microsoft Employee
Microsoft Employee

Just to close the issue, I ended up deleting the connecting table, re-uploaded it and re-established the connections. Guess I just got some kind of a bug that was fixed by re-doing everything. This btw happened after I changed the filter from single selection to multiple selection, it worked fine before. None of the other filters were affected. 

View solution in original post

3 REPLIES 3
Michaela_Onu
Microsoft Employee
Microsoft Employee

Just to close the issue, I ended up deleting the connecting table, re-uploaded it and re-established the connections. Guess I just got some kind of a bug that was fixed by re-doing everything. This btw happened after I changed the filter from single selection to multiple selection, it worked fine before. None of the other filters were affected. 

rajulshah
Super User
Super User

Hello @Michaela_Onu,

 

Can you please share the pbix file so that I can validate what is going on?

Hi @rajulshah, thanks a lot for reaching out to me. However, the file contains sensitive company data so unfortunately I cannot share it. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors