Forum Discussion

poojithas's avatar
poojithas
Helper III
4 years ago
Solved

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!

Need Help
  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    Hi,

    Please set the data type as whole number for sort column

    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


6 Replies

  • Hariharan_R's avatar
    Hariharan_R
    Solution Sage
    4 years ago

    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.

    2. Use that new column to sort

    Check the visual now,

    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


    • poojithas's avatar
      poojithas
      Helper III
      4 years ago

      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.

       

      • Hariharan_R's avatar
        Hariharan_R
        Solution Sage
        4 years ago

        Hi,

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

        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