Sorting legend by alphabet in a tree map

[Anonymous]

How to sort the legend values by alphabetically in a tree map? 

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

TreeMap is only sorted by the size of 'Value'.

As a workaround, you can create a sort column in the PowerQuery Editor and apply it to 'Value' of TreeMap, then add the original "value" field to the 'Tooltip'.

1)sort column ‘Type’ in ascending order

2) add an index column

Result:

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous , I doubt there is an option for that. Usually, sort option is there in three dots