Forum Discussion
How to Change X Axis Label Date Format
- 5 years ago
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.
You can use custom format strings for that and keep the axis continuous.
Creating a simpler and chart-friendly Date table in Power BI - SQLBI
Regards,
Pat