month-year format on x-axis instead of year-month

[crobaseball]

I have a clustered column chart which looks like below.  As you can see the format shows as year-month.  I do NOT want to unconcatenate the x-axis but instead want to have the format as month-year.  Can't for the life of me figure this out.  Is there an easy way to do this or do i need to create a date table in order to accomplish this?

[crobaseball]

thanks!!

[ryan_mayu · Accepted solution]

@crobaseball 

if you have a datetime table then create a column

month-year = FORMAT('Table (2)'[date],"mmm")&year('Table (2)'[date])

if you don't have a datetime table, then create this column in the fact table

[crobaseball]

Actually, there's another problem.  The sort now takes place by alphabetical instead of by time.  How do I solve this issue?

[crobaseball]

Ok, I'm being picky, but when I tried to put a space in after 'mmm' to 'mmm ' it went to this.  I also just tried to put a space in, 

month-year = FORMAT('HVCU_sessions_new_vs_returning05-19to05-21'[Date (Year Month)],"mmm ")& " "&year('HVCU_sessions_new_vs_returning05-19to05-21'[Date (Year Month)])

which also returned the below snapshot.  is there a way to keep the diagonal look?

[ryan_mayu]

@crobaseball 

I didn't find the settings for that. I think that depends on the size of your visual