Forum Discussion
Resolver IIIFilter interaction matrix charts
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).
Solution SupplierMagikJukas, 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.
- MagikJukas
as you can see, it evaluates there is nothing outside these periods.
I suspect the solution is to build a formula that ignores the period... I am struggling to figure it out though.