Forum Discussion
How to Change X Axis Label Date Format
Thank you parry2k for attaching the reference material, So If I understand it correctly when using continuous, I pretty much get what I get for labels and won’t have control of their display but I can see the whole picture graph.
Alternatively, I could use categorical which will allow for labels to formatted how I desire, but each data point will receive a data label. The result is that the amount of data that can be displayed in the graph pane is limited, resulting in the scroll wheel and not being able to view the graph in its entirety if there are more than a few points.
So essentially, with Power BI’s current functionality I pretty much have two options if I wanted to display daily data (such as throughput, yield, profit, etc.) for a long duration like a year or quarter
- Live with the format autogenerated to show the whole graph
- Change the format resulting in a scroll wheel if there are two many points for the labels to fit
If that’s the case, the autogenerate labels are the lesser of the evils. Thank you again for the information.
Hum. Try with a Date instead of DateTime.
Thank you for the suggestion,
Fomating appears to work with the Viloin chart, but with the standard charts I've tried (Bar, line, Area) it seems to have no affect and Scatter seems to force individual X axis labels like catagorical, creating the scroll bar issue and not being able to visualize the one graph at once when daily data is presented for more than a month or so. So far changing to Date from Datetime, still prevents format control for some reason.