Sort Column variables in Matrix visual

[Anonymous]

Hi, 

I am new to Power BI and trying to figure out how to sort column items/variables in Matrix visual. I am using Matrix table visual and my column has Gender - Men, Women & People. The table is automatically listing the variables in alphabetical order, i.e. Men, People & Women (please see screenshot below). I would like to order them as Men, Women & People. 

Can someone please let me know how to do that. Thank you. 

[Icey]

Hi @Anonymous ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards,

Icey

[Greg_Deckler · Accepted solution]

@Anonymous - So, in general, you need to add a "Sort By" column and set the "sort by" for the column that has People, Women, Men to this sort by column. The specifics of this implementation will vary depending on your data. If you have People, Women, Men as row values in the same column, then you could implement a conditional calculated column in Power Query that was basically, if Men, 1, Women, 2, People, 3. Then in Power BI Desktop after import, just set your Sort By column for the original column to be this new calculated column.

[Anonymous]

Hi Greg - Thanks a lot for the quick response. Greatly appreciated. 

I was able to resolve the issue as per your instructions. Thank you very much.