Forum Discussion
Solved
Changing format from December to Dec on chart
Hello everyone, I would like to change the formatting of the following graph Instead of reading the full dates in the x axis I would like an abreviated version such as Jan, Feb ect. ...
Hi,
Assuming the Months on the X-axis have been dragged from the Calendar Table, create this calculated column formula in the Calendar Table
Month name short = format(calendar[date],"mmm")
Ensure that this column is sorted by the Month number column. To your visual, drag this new column.
Hope this helps.
Hi,
Assuming the Months on the X-axis have been dragged from the Calendar Table, create this calculated column formula in the Calendar Table
Month name short = format(calendar[date],"mmm")
Ensure that this column is sorted by the Month number column. To your visual, drag this new column.
Hope this helps.