Forum Discussion

mmoroni's avatar
mmoroni
Helper I
5 years ago
Solved

Sort Date hierarchy with year

I have a visual that takes the date hierarchy of month; however it places December 2020 to the far right.  I am trying to have the columns go from Oldest to newest, or vice versa if needed.  But as i...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi mmoroni ,

    I created a sample pbix file(see attachment) for you, please check whether that is what you want. If no, please provide some sample data with Text format and expected result with examples. Thank you.

    1. Create a custom column to get YearMonth in Power Query Editor

    2. Create another month name to replace the month of date hierarchy

    Month = FORMAT('Table'[Date],"mmmm")

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi mmoroni ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want. If no, please provide some sample data with Text format and expected result with examples. Thank you.

1. Create a custom column to get YearMonth in Power Query Editor

2. Create another month name to replace the month of date hierarchy

Month = FORMAT('Table'[Date],"mmmm")

Best Regards