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

Thanks for the quick reply!

 

A screenshot, sure. "Week van inschrijving" has the format Date in Power BI desktop. The screenshot is from the webapp.

 

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.

    • Pieter's avatar
      Pieter
      New Member
      9 years ago

      Thanks a lot Anonymous, that helped.

       

      Not very intuitive though.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Pieter Think of the Desktop as 2 different environments. When you load data you are using "Power Query" to do the ETL. Then after you "Close & Apply" the data is loaded into a Tabular Model. Much in the same way you would do checks and format things in the Tabular model, you still need to verify and validate correct format there as well.

        Glad it works.

    • 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