Forum Discussion
Matrix : Ordering column when NO rows
- 7 years ago
I don't think you've done anything wrong here, I think you may have found an issue in the matrix visual in that once you have assigned a sort order based on one of the measures there is no way to turn off that measure based sorting. One work around that worked for me was to remove the measure that was being sorted and then re-add it.
So in your case if you remove the [Search Result Views] measure from the matrix you should see the months go back to their alpha-numeric order, then you can add the [Search Result Views] measure back.
Reno_35 wrote:the matrix visual should include a clear "sort by column" option.
Yes, we should not have to resort to "tricks" - I found this idea https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37359649-reset-sorting-on-visuals on ideas.powerbi.com about adding a feature to allow for resetting the sorting on a visual, but it currently only has 2 votes.
i will go vote for this one :)
cheers and regards from sunny Tenerife !