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

 

The language setting we have is English (United Kingdom).

RicardoS's avatar
RicardoS
Advocate III
8 years ago

Hi JoshSiit,

 

I changed the OS language to English (United Kingdom) as well and now it works! The original setting was English (United States).

 

Example 1: Language English (United States) - default 

 

Example 2: Language English (United Kingdom)

 

So bobsel, this is the quickest way to get your Dutch format. Otherwise (if you leave the language on United States), you can do something like this:

 

Unfortunately, this will convert your date into text and then you will lose built-in date functionality like Date Hierarchy.

 

Kind regards,

Ricardo