Forum Discussion

MagikJukas's avatar
MagikJukas
Icon for Resolver III rankResolver 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 ...
BITomS's avatar
BITomS
Icon for Solution Supplier rankSolution 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
    Icon for Resolver III rankResolver 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
      Icon for Solution Supplier rankSolution 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.

       

      • MagikJukas's avatar
        MagikJukas
        Icon for Resolver III rankResolver III
        4 years ago

        See below: I selected the category Spare parts.

        In the chart it only shows 2019 and 2020. I have data for before and after.

        If I deselect the category, 2018 to 2022 are displayed.