Date Hierarchy in a line chart. Month name ordering

[GiulianoPowerBI]

Hello,

I did setup a line chart with an x axis layered for year, month name and day.

One i drilldown on an year, I'm having issue to sort month name by proper order and not like this (by alphabetical order):

How can I solve?

Thank you

[PijushRoy · Accepted solution]

Hi @GiulianoPowerBI 

Create a Monthly lookup table with sort order
Then Month column should be sort by Sortorder column

Create relationship with your Fact table by Month column 
Use the newly created month column in Visual and use Visual sort by month

If solved your requirement, please mark this answer as SOLUTION. Appreciate your KUDOS 

Thanks
Pijush

[jjrand · Accepted solution]

This would work, however I would suggest creating a proper date table

https://www.sqlbi.com/articles/creating-a-simpler-and-chart-friendly-date-table-in-power-bi/

[Anonymous · Accepted solution]

Hi @GiulianoPowerBI ,

I can provide you with a schematic schedule Please check:

DimDate = 
ADDCOLUMNS (
    CALENDARAUTO (),
    "Year", YEAR ( [Date] ),
    "Month", FORMAT ( [Date], "MMMM" ),
    "MonthSort", MONTH ( [Date] ),
    "Day", DAY ( [Date] ),
    "DayName", FORMAT ( [Date], "DDDD" ),
    "WeekDay", WEEKDAY ( [Date],2 ),
    "WeekStart",
        [Date] - WEEKDAY ( [Date], 2 ) + 1
)

You can sort by any column.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[PijushRoy]

Hi @jjrand 

In DateTable, need to change the SortBy order for Month. 
Otherwise it will sortby Alphabetic order

@GiulianoPowerBI If you using, DataTable, please use DAX Month('DateTable'[Date]) to create another column for MonthNumber.
MonthName should be SortBy MonthNumber column (assuming your year start from Jan to Dec)

If solved your requirement, please mark this answer as SOLUTION. Appreciate your KUDOS 

Thanks
Pijush

[PijushRoy · Accepted solution]

Hi @GiulianoPowerBI 

Create a Monthly lookup table with sort order
Then Month column should be sort by Sortorder column

Create relationship with your Fact table by Month column 
Use the newly created month column in Visual and use Visual sort by month

If solved your requirement, please mark this answer as SOLUTION. Appreciate your KUDOS 

Thanks
Pijush

[jjrand · Accepted solution]

This would work, however I would suggest creating a proper date table

https://www.sqlbi.com/articles/creating-a-simpler-and-chart-friendly-date-table-in-power-bi/