Filter slicer using relationship

[thethakuri]

Hi,

I have a job table that has many-to-one relationship with client table with client ID as a foreign key. In the visuals, I have job table with some filters. What I want is use client as a slicer. Currently it shows all clients. I just want to limit it to whatever clients are shown in the job  table with the filters.

Regards,

Ash

[Anonymous]

Hi @thethakuri ,

Has your problem been solved? If not, can you provide some screenshots to explain your problem?

In your slicer, which table does the client field come from?

During my test, the client is in the client table, and the slicer can successfully filter.

If you want to use the fields in the job table to filter the fields in the client table, then you can change the relationship flow to both.

Best Regards,

Stephen Tao

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

[thethakuri]

Hi @amitchandak ,

Thanks for your reply. Can you please explain what exactly will the measure be? How do I reflect the filters applied to job table?  

[amitchandak]

@thethakuri , refer to this. This is for two slicers, but work for single slicer too

https://www.youtube.com/watch?v=cyOquvfhzNM

[amitchandak]

@thethakuri , Create a measure in you table.

example

countrows(Fact)

And use that in the visual level filter of slicer and check value is not blank ( Use advance option) . Drag measure into visual level filter of client and then try