Forum Discussion
Solved
Custom Sort on Grouped column
I have a text column in my query. I grouped it in the data fields and was able to create a matrix. However I need to change the default sort order on this grouped column. Tried reading through the tu...
Since your City field is group on State field, which means it has multiple entries for same State in the table, it's not possible to custom a sort order column to have the State column sorted by this numeric column.
Regards,
If you want the obvious fix vote for https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16895230-ability-to-specify-custom-sort-or-order-on-the-g