Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sort elements manually in table matrix for paginated report - not working

As mentioned in the title. I am trying to sort 3 words in table matrix as followed :

 

1- Morning

2- Afternoon

3- Evening

 

Powerbi Builder is giving me list stored alphabetically.

 

So far I tried to go through the Query Designer by adjusting the query and I tried the Table Properties Sort but both didnt work for tabel matrix, although this worked for regular table visual.

 

Does anybody know why this works for a table but not table matrix ?

2 Replies

  • You should create new Column contain 1,2,3 respectively using Switch fuction then sort the column with created column

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI Anonymous,

    You can take a look at the following link about custom sort if it helps:

    Custom Sorting in Power BI 

    Regards,
    Xiaoxin Sheng