Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Reorder columns order in Matrix

Hi, 

 

I have created a matrix as seen below. With year as rows and month as columns. I want to reorder the column order correctly like: January, February, March,... December, but I cannot figure out how to do it. 

Can someone help me? 

 

Best regards 

Line 

Need Help
  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    Hi

    If you have month number column then you can use that column to sort your month. if you dont have then create Month number as a calculated column using Month(<yourdatefield>) in DAX or create in PowerQuery whichever is easier for you.

     

    Use the "Sort by 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


3 Replies

  • Hariharan_R's avatar
    Hariharan_R
    Solution Sage
    4 years ago

    Hi

    If you have month number column then you can use that column to sort your month. if you dont have then create Month number as a calculated column using Month(<yourdatefield>) in DAX or create in PowerQuery whichever is easier for you.

     

    Use the "Sort by 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


    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks! It helped 🙂

  • krishnaveni's avatar
    krishnaveni
    Regular Visitor
    4 years ago

    Hello ! 

     can you also please help about the slicing of matrix column based on selection rather being sorted alphabetically.

    I mean : 

     

     

    when ever i choose a country from , country filter I want matrix to keep it in the first column . 

    for eg : when i chose Australia after new zeland, matrix would sort the columns alphabetically and propose australia in first place. But, I want New zealand to be kept in first column. 

     

    please let me know how i can work with this problem. I appreciate .

     

    Thank you