cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adityakumar619
Helper I
Helper I

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

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])

 

adityakumar619_0-1632111386065.png

 


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.

 

adityakumar619_1-1632112326706.png

 

adityakumar619_2-1632112359955.png

 

Can someone suggest on this via DAX measure.

1 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

1.png

 

 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.

View solution in original post

5 REPLIES 5
moizsherwani
Helper V
Helper V

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.

@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 

@moizsherwani have you got my requirement completly now?

any one can suggest on this.

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

1.png

 

 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.

View solution in original post

adityakumar619
Helper I
Helper I

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.