How can I reduce the length of the characters on the X-axis?

[HamidBee]

Hi,

I'd like to change the character lengths for the Months like what is below:

The x-axis is dates from the date table. I'm trying to change the length of the months into what is below:

'Jan', 'Feb', 'Mar' etc.

I'm wondering is it possible to do this without creating a new column or table.

Thank you,

 

[KNP]

If you really want to change your date column without adding a column, see below.

[HamidBee]

Firstly I have to say I really like the use of the GIF, looks neat. Honestly, it did cross my mind to don this however I have several other charts and tables where I require the full character length of the month names. As a last resort, is it possible to create....a measure using the code that TheoC kindly provided?

[TheoC]

Hi @HamidBee 

Easiest way is to create a Calculated Column like this:

Column = LEFT ( Table[MonthName] , 3 )

If you don't want to do a new column, then click on the Month Name field and the three little dots to the right of it.  Right Click and go to New Group. Then you can name each month whatever you like 🙂

Hope this helps 🙂

[KNP · Accepted solution]

Honestly, it is probably just easiest to add a short month name column to your date table.

You don't want to change the default format of your date column as it will effect everything.

[TheoC]

Hi @HamidBee 

Easiest way is to create a Calculated Column like this:

Column = LEFT ( Table[MonthName] , 3 )

If you don't want to do a new column, then click on the Month Name field and the three little dots to the right of it.  Right Click and go to New Group. Then you can name each month whatever you like 🙂

Hope this helps 🙂

[HamidBee]

Thank you for your reply. Is it possible to create a measure instead using the code which you provided?

[TheoC]

Hi @HamidBee, unfortunately not in this instance that I'm aware.  If you're adamant on not wanting a column, then go with the New Group approach. However, as flagged, it would be the most appropriate using the new column.

Note, @KNP has just provided a gif that can give you a solution to what you want by changing the formatting. That is a simple approach as keeps the current structure of your model the same, too.  I recommend using @KNP's solution.

[HamidBee]

No worries, Thank you for your help.