Forum Discussion

harshadrokade's avatar
harshadrokade
Post Partisan
3 years ago

Relationship query

HI All,

 

I have the below table & the below is their relationship-

 

A (User ID) Both relationship with B (User ID)

B (User ID) Both relatipnship with C (User ID)

C (Item ID) Both relatiionship with D (Item ID)

 

So A is indirectly in relation with D.

 

I have a slicer added with a field from Table A & the visual is having fields coming from D

 

The slicer field is different than the fields which are connecting table A with D & so any value selected in slicer is not filtering the visual. Also this field in slicer is further ganular level data than the fields that are used for inactive relationship with table D.

 

How can I make slicer with field from table A filter visual with fields coming from table D?

Need Help

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, harshadrokade 

     

    Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. 

     

    Best Regards,

    Community Support Team _Charlotte

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