Forum Discussion
Change date format on charts
Hello Community,
Am facing trouble on changing the date format on 1 chart of the report am generating.
For some reason, the 1st chart you see was doable to change the date format to: DD MMM YY.
However, for the 2nd chart, it was not possible to implement the same given that am looking for MMM YY format.
Please see below for better illustrations:
1)
2)
Any help is greatly appreciated, thank you all in advance!
Regards,
Mo
Hi Anonymous ,
Please refer to my pbix file to see if it helps you.
Create a column.
Column = FORMAT(Targets[Date],"MMM YY")Then create a column to sort.
Column 2 = year(Targets[Date])& FORMAT(Targets[Date],"MM")Then change the column2 type to whole number.
Then sort column by column2.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi Anonymous ,
Please refer to my pbix file to see if it helps you.
Create a column.
Column = FORMAT(Targets[Date],"MMM YY")Then create a column to sort.
Column 2 = year(Targets[Date])& FORMAT(Targets[Date],"MM")Then change the column2 type to whole number.
Then sort column by column2.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Please refer to my pbix file to see if it helps you.
Create a column.
Column = FORMAT('Table'[date],"MMM YY")If I have misunderstood your meaning, please provide your pbix file without privacy information and your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi There,
It did the trick and now the day format is shrinked. However, there is a little problem with it.
It looks like the new format is not sorting in date order; instead, it is sorting out everything alphebitically.
Below screenshot is posted for illustiration:
Thanks again for your support.
Regards,
Mo
Hi Anonymous
I did sort column by date and an error message came up stating:
"We can't sort the 'Column' column by "Date". There can't be more than one value 'Date' for the same value in 'Column'. Please choose a different column for sorting or update the data in 'Date'. "
Below link is a sharable link for you to review the file w/o privacy info:
https://drive.google.com/file/d/1HtuVfyN7F7uvBp8UZK3BT-voeU942rs2/view
Thank you,
Mo