Matrix : Ordering column when NO rows

[Reno_35]

hello all,

i feel so stupid but i can't find any answers to my simple problem.

i have a very simple matrix where i only use measures and columns.

for the measures, i picked the option "values => show on rows"

here is the result : 

from there, i just would like to sort my columns, and i just can't.

if i add a field in the rows... the my columns are properly sorted the way i want :

but if i remove the rows data, the matrix sorts the columns by the results.

please help 🙂 

thank you all for your attention

[d_gosbell · Accepted solution]

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]

d_gosbell,

Thank you for the tip ! it worked perfectly 🙂 i never would have thought about that i was stuck ahah

the matrix visual should include a clear "sort by column" option.

thanks a million again for the trick !!

[d_gosbell]

---

@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.

[Reno_35]

i will go vote for this one 🙂

cheers and regards from sunny Tenerife !