How to shorten Months into Mmm format for visuals

[harsin]

I have created visuals with date on the x-axis, due to space I want to shorten the months to Mmm format on the visual (ideally mmm-yy is possible).

I have tried creating a new column that shows this format but when I use it to build the visual it shows the month name in full.

[Anonymous · Accepted solution]

Hi, @harsin

Based on your question, here are my answers.

First create a table including Month and Year columns.

Then use the DAX code to create a New Column.

Column = LEFT('MonYear'[Month],3) &"-" & RIGHT('MonYear'[Year],2)

This will give you the results you want.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idrissshatila]

Hello @harsin ,

if you create a calculated column that says 

month = format ('YourTableName'[Date],"mmm")

this should return month short like Jan and Feb

[harsin]

Thanks Idrissshatil, I tried this poreviously and it did not work