Forum Discussion
Sort Matrix Column Headers by dynamic in slicer context
Hello all, unforgetly i'll need help with my visual. Does anybody have a solution to sort header dynamic in filter context? I would like to sort it by the average value based on my Year/month fi...
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
I had feared that. I think it will almost being that.
Calculated table with Averages of each Periode and Country. Periode and Country are the filters for this view.