Forum Discussion
Filter report based on slicer values
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
2 Replies
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?Anonymous , Check if rajulshah , suggestion can work.
You need to create common dimension tables and join it with three tables and use
refer
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
