Forum Discussion

jaryszek's avatar
jaryszek
Super User
11 months ago
Solved

How to sort chart by 3 date columns?

Hello, I have model like that:     and I am using Dates columns here to create date hieararchy: And now i got not ordered items in visual after adding date hierarchy with sum of ...
Need Help
  • MasonMA's avatar
    MasonMA
    11 months ago

    Hi Jacek, the MonthName is of Text data type. By default, Power BI sorts text alphabetically (Apr, Aug...) so it's why we sort this column by a numeric column.

     

    While Day and Year are both stored as Whole Number. Numbers naturally sort in ascending order (1, 2, 3… or 2023, 2024…), so Power BI doesn’t need a helper column.

     

jaryszek's avatar
jaryszek
Super User
11 months ago

thanks. 

I tried both methods and they worked. 

Can you explain how this "go back to Table view and sort by 'MonthName' column by 'MonthNum'" is working ?

Why Days and Years accordingly adjusted? 

Best,
Jacek

MasonMA's avatar
MasonMA
Super User
11 months ago

Hi Jacek, the MonthName is of Text data type. By default, Power BI sorts text alphabetically (Apr, Aug...) so it's why we sort this column by a numeric column.

 

While Day and Year are both stored as Whole Number. Numbers naturally sort in ascending order (1, 2, 3… or 2023, 2024…), so Power BI doesn’t need a helper column.

 

  • jaryszek's avatar
    jaryszek
    Super User
    11 months ago

    thanks!