Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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.

 

Settlement 1.PNGSettlement 2.PNG

5 REPLIES 5
v-xuding-msft
Community Support
Community Support

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" )
    )

1.gif

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.

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
Not applicable

Hi,

 

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

 

Kind regards

 

Dominic

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.

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
Not applicable

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.

 

PBI - Order By Table.PNG

EricHulshof
Solution Sage
Solution Sage

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


Quality over Quantity


Did I answer your question? Mark my post as a solution!


Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.