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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

cross filtering slicers bug

Hi there,

 

I am using May 2017 Desktop, Import model. 

 

This may be my misunderstanding of cross-filtering on slicers. 

 

I have a page with two slicers. Those slicers have Interactions set to Filter (both ways). Slicer 1 is Year ; Slicer 2 is Class. There are n Classes in each Year.

 

 

When Year 1 is selected on Year slicer then the Class filter shows only those classes in Year 1. Correct.

 

But when the Class BATS is then selected, and then I go back and select Year 2 on the Year Slicer, I get all the Year 2 classes correctly but BATS is still there on the slicer. It should have disappeared. 

 

Is this a bug?

 

 

 

1 ACCEPTED SOLUTION
v-jiascu-msft
Employee
Employee

Hi @Anonymous

 

Please reference this topic, which is the same with yours. https://community.powerbi.com/t5/Desktop/Interaction-between-two-Slicers-doesn-t-work-well/td-p/72578/page/2

It's answered by v-haibl-msft. And there is also a workaround supplied by Sean. Maybe you could submit an idea here: https://ideas.powerbi.com/forums/265200-power-bi-ideas?query=slicer%20uncheck

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-jiascu-msft
Employee
Employee

Hi @Anonymous

 

Please reference this topic, which is the same with yours. https://community.powerbi.com/t5/Desktop/Interaction-between-two-Slicers-doesn-t-work-well/td-p/72578/page/2

It's answered by v-haibl-msft. And there is also a workaround supplied by Sean. Maybe you could submit an idea here: https://ideas.powerbi.com/forums/265200-power-bi-ideas?query=slicer%20uncheck

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi Dale, I understand the logic now. I don't agree with it - the slicer needs more finessing. I'll respond on the other post. Thanks.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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