I trying to sort my Pivot table using Expression option from sort properties but I am not able to achieve what i am looking for.
I have two fields BPclass code and Unit type, from these I am using only Unit type as a dimension in the table and in pivot table this unit type should be sorted out by using above two fields (not Ascending or Descending order) I am looking for custom sorting like rounded in yellow circle in attached screen (Right side of the screen shot)
Here I can not use match or if statements because i have 25 to 30 unit types and codes so i think its difficult. Few more may get add in future.
I don't want create new concatenated field in the data model because data model is freeze and user's do not want to see the codes in the table.
Not sure if you've found a solution to this yet as its 2 months old but remember that The dimension or expression you want to sort on needs to be filtered as simple as possible,What is the expression for Unit type? Use that same expression in the expression box,deselect text and state.
If possible,Can you attach the model?I'll have a look and sort it out for you