RE ORDERING COLUMNS IN MATRIX VISUALIZATION

[EmmaLynch]

Hi,

I have created the below basic matrix - problem is I need to reorder the columns to be AA, A, B, C & D as AA is better than A and therefore needs to show first.  The matrix is sorting is alphabetically, so putting AA behind A, which I dont want.

Could anyhelp be in layman terms please as I am not very technical.

Thanks in advance 🙂

[mhossain]

@EmmaLynch 

1). Create a table using GroupBY  Contract Class and second column as count, and then create a rankx column to rank your 'Contract Class'

2). Drag contract class from above table to matrix visual, and use SORT BY column as per rankx column.

Let me know if above makes sense. will you be using any slicer? Above rankx will be done at total count at Contract Class.

[Sujit_Thakur · Accepted solution]

Dear @EmmaLynch ,
This is what i used to suffer in,

Simply change order in which they are put in the field.
Or 
The best practise is
make a new table by using enter data option from main tool ribbon on the top of screen.
Make such table

Entity         Direction

AA               1

A                  2

B                  3

C                 4

D                   5

Then realted Entitty with the column from the main data table.

Then you can see a sort option ,
here select sort by Direction.(This is column of new table you created ).

It will do the help always 

Please do not hesitate to give kudos 
If this helped select this post as solution

Regards 
Sujit

[amitchandak]

@EmmaLynch , matrix column (a column is used in the column list) sorted alphabetically unless you use sort column for such a column to change that

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column