Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
5 years ago
Solved

Matrix Month Column Wrong Order

Hi all,   I have placed the month name column (below) in a matrix however it does not order correctly.    Month = MONTH([Date])   Month Name = SWITCH('Calendar'[Month],1,"January",2,"February"...
Need Help
Show and Tell
Tips and Tricks
  • jbirco's avatar
    jbirco
    5 years ago

    in the data view click on the month name column and thenunder the column tools tab click the sort bycolumn tab to sort by the month number column 

borensm's avatar
borensm
Regular Visitor
2 years ago

Actually, I figured out how but I'm getting this error message:  

 

jbirco's avatar
jbirco
Resolver I
2 years ago

it should be just the month number not the monthyear 

  • borensm's avatar
    borensm
    Regular Visitor
    2 years ago

    Thank you that worked!