Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |