Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |