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
poojithas
Helper III
Helper III

Sorting Columns in Matrix Visual

Hi All.

I am using a matrix visual with YYYYMM as Columns , cardtype as Rows and few measures as Values.

I am trying to sort YYYYMM in descending order but I do not find an option to do. Can someone please let me know how this can be achieved dynamically. Please note that the datatype of  YYYYMM is TEXT which is coming in directly from the database. We will not be able to bring the date field into the report.

Thanks!

Screenshot.png

1 ACCEPTED SOLUTION

Hi,

Please set the data type as whole number for sort column

Hariharan_R_0-1655365229810.png

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


My Blog :: YouTube Channel :: My Linkedin


View solution in original post

6 REPLIES 6
Hariharan_R
Solution Sage
Solution Sage

Hi

Matrix visual doesn't has option to sort the column values so you need to sort it using "Sort By Column".

 

1. Creat one columns in Power Query Layer like below.

Hariharan_R_0-1655362674958.png

2. Use that new column to sort

Hariharan_R_1-1655362716240.png

Check the visual now,

Hariharan_R_2-1655362747330.png

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


My Blog :: YouTube Channel :: My Linkedin


Hi @Hariharan_R , I have followed the same but by default it is sorted in Ascending order. Is there any additional steps to be done to sort in desc order.

Screenshot.png

poojithas_0-1655363751755.png

 

Hi,

 No other steps required. Check one more time from report view whether sort by column is correctly mapped to the column.

Hariharan_R_0-1655364382177.png

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


My Blog :: YouTube Channel :: My Linkedin


@Hariharan_R  : I have recreated but it is still the same, it is sorted in ascending order instead of descending.
Screenshot.png

 

Screenshot1.png

Hi,

Please set the data type as whole number for sort column

Hariharan_R_0-1655365229810.png

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


My Blog :: YouTube Channel :: My Linkedin


@Hariharan_R  - This worked. thank you!

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.

Top Solution Authors
Top Kudoed Authors