Forum Discussion
Remove Filter Context from Table Visual when Matrix is clicked
Hey there,
I have a matrix visual with the columns "destination" and "order number".
The destination is the first row and the order number the second.
When I open the matrix in one destination, all order numbers are shown. But order numbers could also be placed on another destinations. My aim is to create another visual as a table, where the other destinations of the clicked order number in the matrix are shown.
I think I have to create a special measure for the table visual, where the filter context is deleted. I tried, but with no success.
Could somebody help me?
Thanks and much greetings.
You need to use a shadow copy of your table to do that
see attached
8 Replies
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi lbendlin ,
I have created a simple spreadsheet and a pbix file to explain my aim.Hopefully, everything is clear now.
Thank you!
Is there any opportunity to create a measure for the table visual, that ignores the filter context from the matrix with creating a "shadow table"? I tried your solution with tab editor, it doesn't work 😕
you lost me there. I still don't know what that would have to do with Tabular editor.
To duplicate the table doesn't worked for this problem.
I'm working with own created dataflows, so I have created a new dataflow with the necessary data, almost a duplicate but a little bit smaller.
Now it works. Thank you very much!
