Forum Discussion
URGENT! DATES
Hi Chrispate03
Based on your needs, I have created the following table.
You just need to keep the year and month hierarchies in the visual.
This is the result you want:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
- lbendlin
Super User
Doesn't look like you put the date column on the X axis.
Your chart is hard to read. May want to make the background more subtle.
