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 o...
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


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