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

Formatting a Matrix Visual - Sort by Column

I have a matrix visual as follows and would like to sort the date column in descending order so that the latest date shows first

(09-2022  08-2022  07-2022  06-2022  etc.) 

Following is the matrix visual with dummy data.  

Any way to do this?  Thanks!

 

Image 2 Dummy Data.pngImage Dummy Data.png

 

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey  @ConnieMaldonado 

unfortunately, there is a simple answer - this is not possible. This is because it's not possible to sort the columns by default.

 

For this reason, I tend to create additional columns in my calendar table with corresponding index columns (hidden in the report view). Then I use this feature https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column . In combination with the Field parameters feature, I consider it a valid "workaround".

 

Hopefully, this provides an idea of how to tackle your challenge.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
TomMartens
Super User
Super User

Hey  @ConnieMaldonado 

unfortunately, there is a simple answer - this is not possible. This is because it's not possible to sort the columns by default.

 

For this reason, I tend to create additional columns in my calendar table with corresponding index columns (hidden in the report view). Then I use this feature https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column . In combination with the Field parameters feature, I consider it a valid "workaround".

 

Hopefully, this provides an idea of how to tackle your challenge.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Thank you Tom!  The workaround helps.

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.