Forum Discussion
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 ?
- Anonymous4 years ago
HI Anonymous,
You can take a look at the following link about custom sort if it helps:
Regards,
Xiaoxin Sheng
2 Replies
- mh2587Super User
You should create new Column contain 1,2,3 respectively using Switch fuction then sort the column with created column
- AnonymousNot applicable
HI Anonymous,
You can take a look at the following link about custom sort if it helps:
Regards,
Xiaoxin Sheng