Nope, not missing anything. Doesnt look like it’s possible (or at least without some convoluted DAX, which doesnt seem worth it)
You can vote for the feature here:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11185431-add-a-multiple-columns-sort-featue
