Forum Discussion
Filtering visual from matrix by only selecting rows
Hi benjos23
Thank you for the detailed explanations and screenshots. I understand what you're trying to achieve. But to my knowledge, there is no good way to achieve it. As you can see, when you remove interaction, the line chart will not be affected by the matrix, so the Account row can't filter the line chart.
When using measures, we can use REMOVEFILTERS to remove some filters in the context. However, in a line chart, we cannot use DAX functions like REMOVEFILTERS to remove the filter interaction on the x-axis column. At the same time, only Column can be added to x-axis. The x-axis field (Month column) is affected by the filter interaction from Matrix visual. We cannot make only the x-axis field not affected.
Best Regards,
Jing
Hi benjos23
What is the field on x-axis in the line chart? Can you show the current result with the measure and the desired result you want to achieve?
Best Regards,
Jing
Hi Anonymous,
The x-axis field is the same as the one used in the matrix columns and the measure, i.e. DateDim[Month].
Currently, if I select a month in the matrix, the line chart will be filtered out (which I don't want) :
If an account number is selected, the chart will also be filtered (which I want) :
However, I would like that the line chart does not get filtered when I select a month in the matrix :
(here, I removed interactions between matrix and line chart, but it is not something I want as it will also remove interaction when an account number is selected in the matrix).
In an ideal world, I would even like that the selected month get highlighted in the line chart, but I don't think it is possible.
Hi benjos23
Thank you for the detailed explanations and screenshots. I understand what you're trying to achieve. But to my knowledge, there is no good way to achieve it. As you can see, when you remove interaction, the line chart will not be affected by the matrix, so the Account row can't filter the line chart.
When using measures, we can use REMOVEFILTERS to remove some filters in the context. However, in a line chart, we cannot use DAX functions like REMOVEFILTERS to remove the filter interaction on the x-axis column. At the same time, only Column can be added to x-axis. The x-axis field (Month column) is affected by the filter interaction from Matrix visual. We cannot make only the x-axis field not affected.
Best Regards,
JingHi Anonymous,
That is what I thought 😞 Nevermind, thank you very much for your replies and your help ! Sometimes it is better to simply move on.
Best regards,
Benjamin