Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 ?

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
mh2587
Super User
Super User

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



Muhammad Hasnain

#LetsConnect https://www.linkedin.com/in/hasnain2587/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.