Forum Discussion
AmyS7
3 years agoNew Member
How to change data format in report?
Hello teams, I want to change the display format of data on the report, like 2022 November 20 to 11/20/2022 I have tried to change format in column tools, but it not work. please give me some advi...
- 3 years ago
I would suggest to create a YY/MM column in the Date Table with this code:
YY/MM = FORMAT ( [Date], "YY/MM" )Then pull this column as your axis field.
FreemanZ
3 years agoSuper User
I would suggest to create a YY/MM column in the Date Table with this code:
YY/MM = FORMAT ( [Date], "YY/MM" )
Then pull this column as your axis field.