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
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 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