Slicer not filtering across visuals. Noobie question.

[naninamu]

Hi everyone. This is frustrating because although I'm new and learning, I feel this should be simple.

I have two tables: one big table showing smoking rates and another with 3 rows that shows commentary I'd like to appear when Male, Female or All is selected on the slicer.

Table 1 Smoking Rates

Table 2 - Comments

I have linked them as follows.

This is my viz:

The idea is that when "Female" is selected on the dropdown, it will show the female line chart (which it is), but also only the row relating to Females in the commentary. Currently, despite linking the charts, it is showing commentary for males, females and all.

I have tried playing around with the direction of the relationship but nothing seems to work.

Can someone enlighten me as to what I'm doing wrong?

Many thanks!

[naninamu]

Hey Arul - thank you so much! I often have this problem in Excel so I should've thought of it. Great pick up and I'll definitely remember this going forward. Thanks again!!!

[Arul]

@naninamu ,

I think in slicers you are using Gender column from smoking rate table instead from smoking comment table. I assume that filtering direction singlre from Smoking comment->Smoking rate (1:*). If that is the case Gender column in Smoking comment table won't be filtered by Smoking rate table Gender column since filtering won't happen from Smoking rate table to Smoking comment.

Thanks,

Arul

[naninamu]

Thanks Arul.

Yes, I was using Gender from the Smoking Rate table. So I have changed it to Gender from the Comment table.

This is how the data model is set up:

However, now when I filter on Female, the Comment table filters, but all my line graphs have disappeared.

Thanks for your help, but any further thoughts on what the issue it?

Many thanks, Andrew

[Arul]

@naninamu ,

If possible could you share the sample file? Are you using any measures or they are direct columns?

Thanks,

Arul

[naninamu]

Hey Arul - no measures involved, it's meant to be simple with just columns and tables. The file can be downloaded here

Thanks in advance, Andrew

[Arul · Accepted solution]

@naninamu ,

You have to trim the Gender column in the Smoking rate table since it is having additional blank spaces it is not giving the expected result. If you go to the Power query editor and under thre transform you can see format option click that and use trim after selecting the Gender column from the Smoking rate table.

Thanks

Arul