Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filter table based on clicking the values in other table(matrix)

Hello everyone, I have one matrix and one table. The matrix is shown below.   In this matrix. It tells the total strength of the grade in each section. For example, for Fifth grade C section the t...
v-evelk's avatar
v-evelk
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Do I correctly understand that you want that click by matrix cell has to filter data in the table, but click by a table row doesn't has to filer matrix?

Also, do I correctly understand that currently they filter each other?

If so, in my answer I showed how to manage filtering relationship. Using this feature you can switch of filtering for a certain visual.

Probably, I explained too short and unclear so, please read this article to figure out with Visuals Interaction feature.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]

Anonymous's avatar
Anonymous
Not applicable
6 years ago

There is little deviation in understanding. The matrix and table are not filtering each other. I cant establish relationship between those two. Simply I have one matrix and one table with no relationship.