Forum Discussion
dsi
2 years agoFrequent Visitor
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...
Anonymous
2 years agoNot applicable
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.
dsi
2 years agoFrequent Visitor
Hello,
thank you for replying, but this solution was well known.