clicking on any row of one table selects the filter in slicer there by filter other table

[adityakumar619]

I have two tables i.e sheet1 and sheet2.

I have created a table using table tools and applied via slicer by using below.

Measure = SUMMARIZE(Sheet1,Sheet1[CPL])

My requirement is if i select like below in sheet1,respective filter in slicer (i.e table) should select and respective data should be seen in sheet2

and if i unselect that row in table,i should see the complete data in sheet2.

Can someone suggest on this via DAX measure.

[moizsherwani]

Hi @adityakumar619 ,

I am not 100% sure I understand your requirement but can you check if the following helps you acheive this.

1) ceating an additional link (relationship) between Table[CPL] and sheet1[CPL]. Make the filter direction be birectional

2) Use the Table[CPL] as a slicer on the report

Clicking the sheet1[CPL] will then select all the related rows in the sheet2[CPL]

Regards,

Moiz

If this post helps, please Accept it as Solution to help other members find it.

[adityakumar619]

@moizsherwani  i have tried this before,here what happening is,data in table2 is filtering out based on the date filter in the sheet1,before clicking any row in the sheet1.Hence iam not able to get the complete data when i unselect rows in table1

you can find in the below pbix file.

https://drive.google.com/file/d/1LpI-NOXeQ1iRb7rA7rf5shVZR4oeyiI5/view?usp=sharing 

[adityakumar619]

@moizsherwani have you got my requirement completly now?

any one can suggest on this.

[v-rzhou-msft · Accepted solution]

Hi @adityakumar619 

I think you can select None in Edit interactions between Table: Sheet2 and Date slicer by Sheet1.

For reference: Change how visuals interact in a Power BI report

 Best Regards,
Rico Zhou

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

[adityakumar619]

https://drive.google.com/file/d/1LpI-NOXeQ1iRb7rA7rf5shVZR4oeyiI5/view?usp=sharing