Date Hierarchy Stacked Column Chart- Not Displaying Correctly

[Anonymous]

Hi,

I am having a simple issue getting a stacked column chart to show the data in the correct chornological order when it comes to months. The data recorded in days, but January should be 2020 but is in position one. It is correct when shown in date hierachy.

[v-xuding-msft]

Hi @Anonymous ,

Please create a calendar table and create a one-to-many relationship between the tables. 

Calendar = 
VAR _calendar =
    CALENDAR ( "10/1/2019", "5/1/2020" )
RETURN
    ADDCOLUMNS (
        _calendar,
        "Year & MonNum", YEAR ( [Date] ) & MONTH ( [Date] ),
        "MonthName", FORMAT ( [Date], "mmmm" )
    )

For more details, please reference this thread to have  a try: https://community.powerbi.com/t5/Service/January-is-in-the-wrong-place/m-p/921137#M86423

Best Regards,

Xue Ding

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

[Anonymous]

Hi,

I have tried this but it doesn't seem to work for me?

Kind regards

Dominic

[v-xuding-msft]

Hi @Anonymous ,

Do you create a new column of Month? Please use the new column rather than the date hierarchy. And please share a few screenshots which is using my formula.

Best Regards,

Xue Ding

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

[Anonymous]

Thanks, I managed to resolve this by creating a new column for month and then a new table for ordering and creating a relationship between the two.

[Anonymous]

You need to lookup date tables in Power BI and create one then work from there, because it solves issues like this easily