Scaling X Axis on a line chart so that a full year fits the view

[amelindah]

I want to see the historical volumes during a calendar year, where I can easily see the monthly difference between each year. I have found a crude session, but it forces me to use fake dates (I trick the data using a date with a year that is irrelevent and put the data in columns separated by the correct year, stored as text).

To make this chart look good, I use a column for dates with a false year (like 2000) and columns for each of the right years (where the year is stored as text), but then the axis (while looking great!) shows the year 2000, which is false.

To achieve the chart below, here, I have one column for the correct date and another column for the volume value. Then, in the chart details, I can use the hifile date and delete the year to overlap by day of the year. BUT the scale is so big, it doesn't make sense because you have to scroll and scroll and you can't see a year-round snapshot.

Both charts show the same data, the same number of data points. Both display daily values.

Main question: How can I have my chart scale down so that a full year fits the screen with daily data points?

[v-xicai]

Hi  @amelindah  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @amelindah ,

You may create a calendar table, put the calendar[Date] into Axis of line chart. Then if you may click drill up and drill down options to see data of every level date hierarchy.

Calendar=CALENDARAUTO()

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nandukrishnavs]

@amelindah 

Define a table for the current year. For example 1-1-2020 to 31-12-2020. The column type should be the date.

Then use that column as the X-axis of your line chart and enable Date Hierarchy. As per your snapshot, create 4 measures 2017 total, 2018 total, 2019 total, and 2020 total. Each measure you can apply a filter condition to filter the selected period. Then add these measures into the value field of the line chart.

Now you will get an option for drill-down, expand the next level, expand the full level (Quarterly, Monthly, Daily). 

If you can provide sample data set and expected output that will be helpful.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂