Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Date Hierarchy Stacked Column Chart- Not Displaying Correctly

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 bu...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

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

     

    Kind regards

     

    Dominic

    • v-xuding-msft's avatar
      v-xuding-msft
      Community Support
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago

        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.