Forum Discussion

Chrispate03's avatar
Chrispate03
New Member
2 years ago

URGENT! DATES

Good afternoon. I am attempting to create periods on my x-axis for 2023 and 2024. I have these periods as the months of the year (ie., January=1), but I can not get the periods to start over for 2024...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Use a calendar table in your data model and put the Date column into the X axis.  Power BI will take care of the correct display aggregation.

Chrispate03's avatar
Chrispate03
New Member
2 years ago

I am still unable to achieve the result I am looking for. I have created a calendar table and have connected the two on the model view. But, when I try to use the calendar to sort the information consecutively across multiple years I get the following. 

 

 

If I just put the period number data from my original source data it for whatever reason it places 2024 at the beginning of the chart instead of after 2023. 

 

This is the chart I hope to achieve but with the dates in the right order and to include all period numbers. I have tried to set the x-axis to continuous but this is the way that it displays by placing 2024 before 2023