Forum Discussion
Line Chart X-Axis Date Formatting
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.
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,
1 Reply
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,