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.
Mike88 to understand continuous and categorical, read this post. Basically, in the case of continuous, you have no control over the format.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
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.
Mike88 precisely, you got it. Not sure what your real requirements are, really to see data by date, usually you can always have drill thru from year -> Quarter -> Month -> Date, etc....so for example if you drill down by month, you have a maximum of 31 dates and it might fit in a month but again it is not one size fits all.
Anyhow, you have an understanding of what needs to be done to control the date format, you can go ahead with what you think works best for you.
Good luck!
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡