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

[Anonymous]

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 ?

[Anonymous · Accepted solution]

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

[mh2587]

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