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 but is in position one. It is correct when shown in date hierachy.

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

  • 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.