Forum Discussion
Solved
Can I sort matrix visual based off a specific column?
Let's say I have table like this: Country C1 C2 C3 Product Sales Sales Sales P1 10 20 50 P2 30 10 60 P3 50 0 10 Product is the rows in the matrix, Country is...
I showed that in my measure, with ISINSCOPE.
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.