Date Heirarchy on Column and Line Charts - Grouping and not Ordering?

[BlueMinnowBPS]

I have some gas consumption data from Sep 2024 to Jan 2025. For some reason, Power BI is putting the Jan 2025 data infront of the 2024 data. Is it because it's just grouping the months without the year context? How do I fix this? Thanks!

[Anonymous · Accepted solution]

HI @BlueMinnowBPS,

I'd like to suggest you create a new field to store the fiscal year month and use this as category of the visual. It should help you to group the records to the correct date ranges.

For fiscal year month field(text type) sorting, you can refer to the following link:

Custom Sorting in Power BI  

Regards,

Xiaoxin Sheng

[BlueMinnowBPS]

So I extracted only the Date from the Date/Time column, this appears to have resolved my issue and the heirarchy is ordering the columns properly now.

[BlueMinnowBPS]

FYI, don't add the new date field to the visual and remove the old date/time field, it won't update the visual to add the year context. Deselect the date/time field first, then add the new date field. Power BI still glitchy after all these years...

[Jihwan_Kim]

Hi,

I am not sure how your calendar dimension table looks like, but I assume that the current situation is, 

-> Month name is sorted by month number.

Instead, please try something like, 

-> Month name: sort by fiscal month number

Sort one column by another column in Power BI - Power BI | Microsoft Learn

[BlueMinnowBPS]

It's not a dimension. It's just a column within the Fact table with date/time as data type.

There's no sorting. If you select the the month, there's no column options.