Forum Discussion
Power BI Timeline X axis Amendment
Hi,
I have successfully built a timeline on the Power BI tool. May data X axis goes from March next year (2021) till December 2022. The x axis displays the month name only. How can i make the axis display March 2021, April 2021, May 2021 etc.
I have tried to format my dates in transform data, but this does not work.
Hi Anonymous ,
You can use date hierarchy for the x-axis and click expand to next level:
Then it will show like:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
3 Replies
- amitchandak
Super User
Anonymous , In you date table table you can have these columns
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")Sort month year on Month Year sort ans use Month Year in visual - https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
v-deddai1-msftCommunity Support
Hi Anonymous ,
You can use date hierarchy for the x-axis and click expand to next level:
Then it will show like:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
