cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Format the date in my table

Hi,

 

I am trying to get my dates into the short date format i.e. dd/mm/yyyy

 

The below is the current format in my table.

Please help.

 

datePBI.PNG

1 ACCEPTED SOLUTION
Super User II
Super User II

If you select your Date field in your model you can change the formatting.  That formatting will get used whenever you use that field in a visual after that.

DateFormat.jpg

View solution in original post

2 REPLIES 2
Super User II
Super User II

If you select your Date field in your model you can change the formatting.  That formatting will get used whenever you use that field in a visual after that.

DateFormat.jpg

View solution in original post

Super User III
Super User III

@AOT with sep 2019 update, you can add custom format.  here is the link






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors