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
Microsoft Employee
6 years ago

Hello,

 

You shoul enable "Edit Interactions" option and switch off filtration for Matrix as on picture below

 

 

Kind Regards,

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for your reply Evgenii Elkin. I posted my scenario and i need a solution for that. I attached the sample results as image. I didnt acieve the scenario in powerBI. So please give me a solution for the scenario i explained on top. At this stage I have one table and one matrix. I dont know how to proceed after that [(i.e) by selecting a value in matrix the table should filtered to show the selected details]. Thanks in advance. 

    • v-evelk's avatar
      v-evelk
      Microsoft 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.