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

[Boss]

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 😉

[Boss · Accepted solution]

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]

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.

[Anonymous]

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.