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

Pieter's avatar
Pieter
New Member
9 years ago

Like this:

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Pieter Your screen grab shows the "Query Editor" - after you "close & apply", click on "Modeling" in the header. Under the "Formatting" header do you have "Data Type: Date" and a selected format?

This is the model layer, you need to explicitly define the format there as well.