Forum Discussion
Resolver IIIFilter interaction matrix charts
Solution SupplierHi 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.
Resolver IIIthanks 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
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
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.
- BITomS
You still have the 'Filter' behaviour selected in your screenshot which will not work for what you are trying to achieve. Please change the interaction so that the middle option is selected (Highlight):
Then try your matrix selection again and let us know how this goes.