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.
Go to Solution.
I would suggest to create a YY/MM column in the Date Table with this code:
Then pull this column as your axis field.
View solution in original post
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,
Appreciate with a Kudos!! (Click the Thumbs Up Button)Did I answer your question? Mark my post as a solution!
Please try belowformat(date_column,"yyyy-mm-dd")Then you can change the date format in power query editor
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!