Line Chart X-Axis Date Formatting

[markbell]

I have a date formatting issue on a Line Chart where if I have less than 6 days selected, it shows the x-axis date as "dd MMM, hh[AM/PM]". For 6 or more days, it displays ""dd MMM" which is what I always want it to show regardless of the number of days selected.

My data source has the format dd/MM/yyyy and the Charts x-axis type is set to Continuous. I would prefer to keep the x-axis type as Continuous so that it always display the data without a scroll bar for large ranges of dates.

[v-sihou-msft · Accepted solution]

@markbell

In this scenario, if you don't want to have the timestamp in your chart, please change the data type of your date from "Date/Time" to "Date". Also I noticed that you have different part as slicers. I suggest you build them into a hierarchy, and you can drill down like "Year->Month->Date" so that you don't need to keep a long scroll bar on X-axis for long date range. Currently drillthrough is not supported in line chart, I suggest you change it into column chart.

Regards,