Display Year on X Axis Only on Month 1 (Jan)

[UncleLewis]

Hi all,

How can I display the year on Row 2 of the x-axis of a Column Chart?
The Year should only display for Jan and should be aligned below Jan (or J)

The year should not display again until  Jan is encountered again for the following year

The image below is a mock-up from Excel.

I have the 1 letter abbreviation for the Month, and I have it sorted in chronological order, I just cannot figure out how to display the year on row 2 of the x-axis when the month is 1 (Jan)

Thanks

w

[UncleLewis · Accepted solution]

Thanks Phil,

I tried, I just cannot get the year to display on Row 2 of the x-axis, so I ended up opting to show the month name and year when the month number is 1. Not as good, but will have to suffice.

MonthNameAbbr =

VAR __MonthNbr = Month('Calendar'[Date])

VAR __MonthName = FORMAT( Calendar[Date], "MMMM")

VAR __Year = FORMAT( Calendar[Date], "YYYY")

VAR __MonthNameAbbr = CONCATENATE(

                        LEFT(__MonthName, 1),

                        REPT(UNICHAR(8203),__MonthNbr)

                    )

RETURN

    IF(

        __MonthNbr = 1,

        CONCATENATE(CONCATENATE(__MonthNameAbbr,UNICHAR(10)),__Year),

        __MonthNameAbbr

    )

[PhilipTreacy]

Hi @UncleLewis 

You can't do that.  If you have the year on the 2nd row of the X axis, it will be centered on the data for that year, e.g.

Regards

Phil