Forum Discussion
Can I sort matrix visual based off a specific column?
I showed that in my measure, with ISINSCOPE.
I want to have the option to change by any country whenever I want instead of keeping static just for C2. So, if I want to do by C1 and C3, then end user should be able to do that.
To add, I don't want to create a measure where I remove the columns from matrix and explicitly add the country in the measure for example CALCULATE([Sales], Country = "C2") and so on. This is a solution but not something I am looking for since I prefer having to keep the columns.
Sure, have a disconnected slicer for the country selection and in the measure read the current slicer value.
The measure is no longer able to read slicer value using SELECTEDVALUE if it is disconnected.
please elaborate?
How did you change the column total to only include C2? I do not get that point.
What I tried to do was create a new measure just for sorting. This measure would calculate the value based on the value in the slicer and not the column value coming from the matrix. However, for this I had to disconnect the matrix from the slicer but when I did this, the new measure created for sorting no longer works since disconnection led to me not being able to read the value of the slicer using SELECTEDVALUE.