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.
Thank you both for taking the time to response to the question, it's very much appreciated.
I think maybe it’s me not understanding power BI terminology yet to ensure I’m in the correct location or overlooking something since I can’t seem to get to the solution quite yet.
In Past Articles such as this one
There appeared to be a format under modeling that could change the display labels
However, when I tried to replicate this I find the fomat area now in it’s own tab (assuming an update from the past few years since the reference post was made) and does not appear to change the graph appearance at all.
In terms of the cutom format strings, would these be located in the “Relationship” section? Following along the article it appears I am in the correct location based on the accompanying selection options. I attempted to make a custom format, and nothing changes on the graph.
Article Ref:
My attempt:
Is there something unique with Area graphs or groupings that may be preventing this, or am I just missing the mark? Either way your help in pointing me in the right direction is greatly appreciated.
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.
