Sort Matrix Column Headers by dynamic in slicer context

dsi 

you cant dynamically change the sorting order of the columns base on a measure in a matrix . 

but what you can do , is set a static order for the column you are using in the column setion for the matrix.

you can sort base on your knowledge of your data .

lets say, you know that almost always A is the highest, then you give it an index of 1 . etc...

( you create a sorting column in power query) 

best regards 

Hi dsi 

Please try this:

I create a set of sample data:

Then copy the column which you need to sort and click Enter Data:

Then Transform data > Merge Queries:

Close&Apply,

select the column and click Sort by column, select the sort column.

The result is as follow:

^{Best Regards,}

^{Zhengdong Xu}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}