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
Ritaf
Responsive Resident
Responsive Resident

Sort Matrix By Grand total row

Hi all,

I want to Sort my Matrix  vizual (like on picture) columns by grand totals.

Is it possible to do this without adding calculated columns?

 

Thanks a lot RitaCapture.JPG

 

 

 

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@Ritaf , I doubt there is an option for that. It will happen by default ascending sort or based on sort column. You can create a sort column based on these values, but that would be static.

View solution in original post

v-yingjl
Community Support
Community Support

Hi @Ritaf ,

Currently there is no option about sorting by grand total in matrix visual directly, you can consider create a conditional column in power query editor then sort by this custom column, refer this sample: Sort Matrix by column total and row totals  

 

Also, here is an idea about sorting by row totals in matrix, you can vote for it to help us improve power bi and make this feature coming sooner.

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

3 REPLIES 3
v-yingjl
Community Support
Community Support

Hi @Ritaf ,

Currently there is no option about sorting by grand total in matrix visual directly, you can consider create a conditional column in power query editor then sort by this custom column, refer this sample: Sort Matrix by column total and row totals  

 

Also, here is an idea about sorting by row totals in matrix, you can vote for it to help us improve power bi and make this feature coming sooner.

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

Ritaf
Responsive Resident
Responsive Resident

Thank you very much.

I tried to assitent my collegue whose works in Tabular mode an have an access only for measures creating, i understand that unfortunately there is no way he can do this wothout DBA'S ivolvement .

amitchandak
Super User
Super User

@Ritaf , I doubt there is an option for that. It will happen by default ascending sort or based on sort column. You can create a sort column based on these values, but that would be static.

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.