X-Axis Text Field Dynamic Table Challenge

[jackmtanalysis]

How would you create a graph to format the X-Axis like attached?

The data is in a table and should update automatically with each new month of data.
However, I can't seem to get a text field to work within the table.

This is the table formula, with two "date" fields "LABEL MO" and "END MO".
END MO is a conventional "mmm yyyy" field and LABEL MO is the text field.

=LET(

END_MO,SORT(UNIQUE(FILTER(Data[Month Year],Data[Month Year]>=TWELVE_MONTHS_FROM_BEG))),

VSTACK(

HSTACK(
"LABEL MO",
"END MO",
"TOTAL MARKET",
"TOTAL "&CLIENT_SHORT,
CLIENT_SHORT&" SHARE"),

HSTACK(

IF(END_MO=MAX(LAST_MONTH),UPPER(TEXT(END_MO,"MMM YYYY")),
IFERROR(IF(MOD(DATEDIF(END_MO,LAST_CALENDAR_END,"M"),MONTH_INTERVAL)=0,UPPER(TEXT(END_MO,"MMM YYYY")),""),"")),

END_MO,

TOTAL MARKET
TOTAL CLIENT UNITS
CLIENT SHARE

I've tried rearranging the fields, keeping and/or eliminating the "Multi-level Category Labels" and many other things that did not work.
I'd like to do this without VBA.

 

[awoohaw]

welcome to the forum. Please help the forum help you and post a data table for the chart?