Forum Discussion
Hybrid matrix sort
I have made a custom matrix with the following measure and I am getting the expected result but I am not able to sort it by the column I want. I wish I could sort it by any of the column either "Ventas Netas" or "Utilidad bruta" and such.
Values for Matrix =
VAR calc = IF(SELECTEDVALUE('Evolucion-Hybridtable'[index])=1,FORMAT([Ventas Netas],"#,###0"),
IF(SELECTEDVALUE('Evolucion-Hybridtable'[index])=2,[Utilidad Bruta],
IF(SELECTEDVALUE('Evolucion-Hybridtable'[index])=3,FORMAT([% Ventas],"#0.0%"),
FORMAT([% Margen Bruto Hybrid],"#0.0%")
)))
RETURN
IF(AND(ISBLANK([Ventas Netas]),ISBLANK([Utilidad Bruta])),BLANK(),calc)
7 Replies
custom matrix means you are adding multiple measures into the values well. Rearrange them there.
lbendlin I didnt mean the columns order but the order of the rows to be sorted by just one of all columns that I am using.
what happens when you click on one of the measure names in your matrix?
lbendlin nothing happens I can not click on it
Hi Experts ,
i wanna to sort the hirarchy of hybrid matrix.....
but im unable to handle sorting
