Forum Discussion

MagikJukas's avatar
MagikJukas
Resolver III
4 years ago

Filter interaction matrix charts

Hello,

I have a matrix table with a hierarchy on the row, years on the column, and values.

On the visual filter, I selected only 2020 and 2021 years.

 

On the same page, I have a charts with all years and values.

 

Problem: when I select one element of the hierarchy, the chart is hiding the years that are not present in the matrix table.

How can I select an element on the matrix table and show all the years in the charts?

 

Thanks

10 Replies

  • BITomS's avatar
    BITomS
    Solution Supplier
    4 years ago

    Hi MagikJukas,

     

    I think you need to use the 'Edit Interations' functionality. Firstly, select your matrix table so that the format option appears in the ribbon. Then select, 'Edit Interactions':

     

     

    On the chart, you should then see the following icons: 

     

     

    If you select the circle with the line through it, it will disable the interaction of the table matrix with your chart which I believe is the behaviour you desire.

    • MagikJukas's avatar
      MagikJukas
      Resolver III
      4 years ago

      thanks for your comment BITomS 

       

      Unfortunately, this is does not work. 

      I do not want to disable it, I want to filter in the chart by using the matrix categories. But everytime I click, past years disappear ( because the matrix is showing only the last two years).

       

      • BITomS's avatar
        BITomS
        Solution Supplier
        4 years ago

        MagikJukas, depending on the type of chart, the 'Highlight' filtering behaviour can be used (the middle of the 3 options):

         

         

        This should highlight (filter) the year selected from your matrix table, but also keep any other years visible on the chart, even if they are not in your matrix.

         

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    4 years ago

    Hi MagikJukas,

     

    Actually, OEMToms has provided the solution for your needs. The reason that you see values of 2019 and 2020 years are blank should be something related to your data itself or the relationships in your model or how you calculated these values.

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

     

    Best Regards,

    Community Support Team _ Caiyun