Forum Discussion

dglsmason's avatar
dglsmason
Advocate I
11 years ago
Solved

Date Display Formats

Using Power BI Desktop to create reports and charts. What is the syntax for displaying dates in specific formats. For example, "01/25/2015" instead of "Monday, January 25, 2015". Etc. Thanks!
  • andre's avatar
    andre
    11 years ago

    click on the time field in your model then you can click on Modeling in the Desktop ribbon and pick the desired date format

     

    Capture.PNG

JoshSiit's avatar
JoshSiit
Frequent Visitor
8 years ago

Hi

 

We are having similar problems. There is no option for formatting English dates (dd/mm/yyyy) in the moddelling section of the ribbon..

Does anyone know how to get dates to format like this?

All our slicers are showing dates in US format where as in the tables, the dates are in UK format.

 

Any help would be appreciated.

 

Thanks

 

Josh

XLBob's avatar
XLBob
Resolver II
8 years ago

JoshSiit I am having the same issue and there is no option under the modelling tab that can let me format the date as dd-mm-yy, the closest I can find in the format is dd-mmm-yy. what's even worse is that the dates looks fine in data view but in the reports view it has time after the dates. big sigh here