Consistently Force Two Digit Year To Second Row Of X Axis

[tecumseh]

Hi,

Using PBID Oct, 2024.

How can I consistently force the 2 digit year onto a second row on the x axis?
As you see in the screen shot, every time the month initial is "J" the 2 digit year is on the first row even though I have UNICHAR(10) in my DAX Code

Thanks,
w

DAX

MonthName_1 = 
VAR __Charcter = UNICHAR(8203)
VAR _MonthNbr = [MonthNumber]

RETURN
LEFT('Date Table'[MonthName],1) & REPT(__Charcter,_MonthNbr) & UNICHAR(10) & 'Date Table'[Year_2Char]

[v-mengmli-msft · Accepted solution]

Hi @tecumseh ,

As far as I know, the X-axis of the visual does not support text wrapping at the moment. But if your visual is small enough, the text on the X-axis will wrap based on space at smaller width.

Date_2 = LEFT(FORMAT('Table'[Date],"MMM"),1)&" "&FORMAT('Table'[Date],"yy")

Best regards,

Mengmeng Li

[tecumseh]

Thanks @v-mengmli-msft ,

I decreased the width of the visual a bit now year is consistently on row 2 of the x axis.

Thanks,

-w

[tecumseh]

@lbendlin ,

Thanks.

I removed the UNICHAR(10) and year from the DAX and added the year in hierarchy
Exact same problem in the chart for all months with the initial "J"


I believe the context is sufficient to avoid confusion
1 initial for month format is very common in financial charts

Thanks,
w

[lbendlin]

I played with this a bit and I don't think you will be able to do this with the standard column chart visual types. You would have to look at custom visuals like Deneb that allow you free placement of the axis labels.

[lbendlin]

Played with it some more.  You would need to tightly control the width of the visual

[lbendlin]

Not possible with the standard formatter.  Instead use a hierarchy.

NOTE: you have three months in the year starting with J, two with M and two with A.  Make sure this is not confusing to anyone.