cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Display a Different Date Format

In my Query Editor I have a date column with the data type "Date". When I put this field in the "Legend" field in the stack column chart, it shows the dates as Days (i.e Monday, July 5, 2020) but I want it like "7/6/2020", just how it is in the query editor data table. Is there any way to change this?

1 ACCEPTED SOLUTION
smitty
Resolver II
Resolver II

Select the date column in the Fields pane, then on the menu, choose Column Tools, Format dropdown and choose the desired format.

HTH,

Smitty

Capture.JPG

View solution in original post

2 REPLIES 2
az38
Super User
Super User

Hi @Anonymous 

pick a column in the right pane and change format in Column tools ribbon

Безымянный.png


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
smitty
Resolver II
Resolver II

Select the date column in the Fields pane, then on the menu, choose Column Tools, Format dropdown and choose the desired format.

HTH,

Smitty

Capture.JPG

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.