Filter report based on slicer values

[Anonymous]

Hello All,

I have 3 tables naming A,B and C having a common column region in it.

My requirement is I need to show a slicer on region and based on region selection my reports should change.

So I create a relationships between all 3 tables using region column.(many to many only).

And took region slicer using Table A .

If I select any value in region then only table A chart is changing.

B and C are not working.

Could any one please help how to fix this

[amitchandak]

@Anonymous , Check if @rajulshah , suggestion can work.

You need to create common dimension tables and join it with three tables and use

refer

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM

[rajulshah]

@Anonymous ,

Can you please try plotting the relationship columns in a table?
Or we can check if the columns has the same data type or not?