Hybrid matrix sort

[Anonymous]

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)

[DataBank]

Hi Experts ,

i wanna to sort the hirarchy of hybrid matrix.....

but im unable to handle sorting

[V-pazhen-msft]

@Anonymous 
Can you put it in a sample pbix and share the file link. 

Paul Zheng _ Community Support Team

[Anonymous]

@V-pazhen-msft @lbendlin 

Here is the file 

https://bposgromero-my.sharepoint.com/:u:/g/personal/adiazn_ransa_net/EUwJwSN71jRFkVD7aa7z9awBLjtMh1... 

[lbendlin]

what happens when you click on one of the measure names in your matrix?

[Anonymous]

@lbendlin nothing happens I can not click on it

[lbendlin]

custom matrix means you are adding multiple measures into the values well. Rearrange them there.

[Anonymous]

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