Forum Discussion

thethakuri's avatar
thethakuri
Frequent Visitor
4 years ago

Filter slicer using relationship

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

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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

  • thethakuri's avatar
    thethakuri
    Frequent Visitor
    4 years ago

    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?  

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.