Power BI Timeline X axis Amendment

[Anonymous]

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.

[v-deddai1-msft · Accepted solution]

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

[amitchandak]

@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

[Anonymous]

Hi,

This is what i tried to do before (creating a month year column and then a month year sorter column).

When i put the month year column in the timeline power bi tool, it showed no data.

any solution?