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
Boss
Frequent Visitor

Slicer 'filtering' other slicer but not the other way around

Good day to all of you,

I have an annoying issues which I cannot resolve. Probably I'm overseeing something simple but I cannot figure it out.

I have a report with a couple of slicers and when using slicer 'RM1' slicer 'country' is filtered according to what is selected in slicer 'RM1', this is fine. However, when I select a country slicer 'RM1' is showing nothing while it is clear there is data to be filtered. Why is this happening?

See attached an overview of the datamodel and an screenshot of the canvas itself. I hope some smartass can help me out 😉

 

2024-05-21_17h09_03.png2024-05-21_17h09_59.png2024-05-21_17h09_31.png

1 ACCEPTED SOLUTION
Boss
Frequent Visitor

Figured it out. It was quite tricky so to say. It seems there was one 'one-many' relation ship from RM1 to another facttable which had 'filtering direction' 'both'. I don't know how it is called but it created some kind of circular reference where the 'COUNTRY' filter was first going through this other facttable and then to the 'RM volumes' table. As this other facttable was containing only data from European countries it could not pass the COUNTRY filter properly through to the 'RM volumes' facttable.

I never experienced such issue before but good to know that filtering direction set to 'both' can cause these filtering issues which can be hard to unraffle as Powerbi doesn't have a functionality to warn you for it.

View solution in original post

3 REPLIES 3
Boss
Frequent Visitor

Figured it out. It was quite tricky so to say. It seems there was one 'one-many' relation ship from RM1 to another facttable which had 'filtering direction' 'both'. I don't know how it is called but it created some kind of circular reference where the 'COUNTRY' filter was first going through this other facttable and then to the 'RM volumes' table. As this other facttable was containing only data from European countries it could not pass the COUNTRY filter properly through to the 'RM volumes' facttable.

I never experienced such issue before but good to know that filtering direction set to 'both' can cause these filtering issues which can be hard to unraffle as Powerbi doesn't have a functionality to warn you for it.

Boss
Frequent Visitor

Hi Neeko,

I tried this approach but it didn't solve it.

RM1 and COUNTRY are coming from two different dimension tables filtering the fact table via a one-many relationship. The strange thing is that the 'slicerfiltering' works fine when selecting countries from Europe. But not when selecting countries from South America. Worth noting is that the data from South America is added to the European data (appending via powerquery). Maybe that is a cause but I cannot figure out what exactly. Columnname dataformat etc are all the same.

v-tangjie-msft
Community Support
Community Support

Hi @Boss ,

 

Select the 'RM1' slicer, then go to the Format ribbon and select Edit interactions. This will show filter icons above all other visuals, including the 'country' slicer. Make sure the 'country' slicer is set to filter when 'RM1' is adjusted.

Repeat the process for the 'country' slicer and ensure that the 'RM1' slicer is set to filter when 'country' is adjusted. This ensures bidirectional filtering between the two slicers.

Please refer: Slicers in Power BI - Power BI | Microsoft Learn

 

If this doesn't help, please let me know if the RM1 slicer and the COUNTRY slicer are derived from the same table or different tables? What kind of modeling relationship do they have with each other?

 

Best Regards,

Neeko Tang

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.