Matrix sorting

[Johannesvd]

Hi all,

i've got a question about formatting in a matrix the result i want to get is something like:

In my mapping tabel i've got amongst others the folowing option:

i already found a option where i can use related to add a ranking to the mapping tabel. But it seems i can only sort on one column (so or only the headers or only the subs), i want both to be sorted first on headers and secondly on  the subs. What do i have to alter or add as measures/columns?

(its a little bit simplified for the example)

Many thanks for your input!

[v-sihou-msft]

@Johannesvd

Currently, there's no secondary sorting based on another column in Power BI. You may submit a feature request on idea.

Regards,