How to change data format in report?

[AmyS7]

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 advise. 

[NikhilChenna]

hi @rathimd , If you are not able to change it from the format option. You can create this caluclated column in your table and using in the axis of your visual,

YY/MM = FORMAT ( [Date], "YY/MM" )

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[rathimd]

Please try below
format(date_column,"yyyy-mm-dd")
Then you can change the date format in power query editor

[FreemanZ · Accepted solution]

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.