Slicer issue with relationship of tables

[gauri]

Hey Team,

I am facing certain issues which i have mentioned below.

I have 3 tables named cash, room, ancl.
Table cash has following columns : 'id', 'type', 'amount', 'date'
Table room has following columns : 'id', 'room type', 'room amount', 'room date'
Table ancl has following columns : 'id', 'ancl type', 'ancl amount', 'ancl date'
i want to add 2 slicers which has these columns in it from any tables which has all the values.
for eg: if i take 'id' and ' type' from cash table in slicers, by applying slicers the values from all the 3 tables should change simultanously.
My slicer is not working fine, it just affects that tables from where we pull the column in the slicer.

[Ashish_Mathur]

Hi,

In the Query Editor, edit the headings of the second and third tables to match the heading of the first table.  Then in the Query Editor itself, append data from all 3 Tables to create a single table.

[rainer1]

Hi gauri,

it may be a problem with your data model.

Can you please share this.

[amitchandak]

Can you share the relationship diagram? You might need a bidirectional relation.

[gauri]

Only many to many relationship is detected on the 3 tables. I hava also tried using bidirectional relation.

[v-xuding-msft]

Hi @gauri ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here. If you are still confused about it, please share some screenshots. Then we will understand clearly.

Best Regards,

Xue Ding

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

[v-xuding-msft]

Hi @gauri ,

Can you please share a sample pbix file? If you can't do that, please share some screenshots about your problem and the formulas if you used. Then we will understand clearly and solve it quickly.

Best Regards,

Xue Ding

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