Power BI Matrix visual values sorting

Hi, I created a matrix with sales, the sales YoY variance and var%. I have separate date table connected to the Sales table. I want to see the sales KPIs by year and customers. Everything is working fine in this matrix except sorting. I want to sort the sales in ascending or descending order. Sometime, I want to see Variance or Var % in ASCE or DESC order but nothing works for me here. I tried to use the sort axis option coming with the matrix itself but this doesn't sort the sales correctly. I tried RANKX but no results. Is there any way to sort the Values in matrix?