Forum Discussion
Can I sort matrix visual based off a specific column?
I showed that in my measure, with ISINSCOPE.
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.
I showed that in my measure, with ISINSCOPE.