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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Allow the X-Axis on a Line chart to fully control date format labels for overlapping time series

A common way to compare data from different time series together is to overlap them, for instance: two separate growing seasons. While the data can be plotted this way, the date always displays the year. So even if I compare 2024, 2023, and 2022. The year value from once of those series, or a reference year for chart purposes, still appears. The way it should work is to allow the year to be turned off and only display months, such as Jan, Apr, Jul, Oct. 

 

See this thread for a discussion of the issue: 

Re: X-axis label formatting not responding in a Li... - Microsoft Fabric Community

 

Here is the best way I've found to deal with it for now. The alterate which shows months would have Apr 2000, Jul 2000, Oct 2000 on the X-axis as labels, since 2000 is the reference year for aligning the data.

_Matthew__0-1765818056509.png

 

Status: New