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

bobsel's avatar
bobsel
Helper I
8 years ago

I've got March 2018 version for PBI Desktop...

 

But still... could you explain the least possible steps to change the Englisch format to the Dutch format?

 

 

JoshSiit's avatar
JoshSiit
Frequent Visitor
8 years ago

Hi, update to the April version and the format you want will be available. That should be the only step.

  • RicardoS's avatar
    RicardoS
    Advocate III
    8 years ago

    Hi JoshSiit (and bobsel),

     

    I have also the latest Power BI Desktop version of April, but I see still the US formats. I think this has something to do with your OS language. What is your language setting over there? 

     

    I have read this blog about it:

    https://superfarb.com/power-bi-customising-date-format/

     

    Thanks in advance.

     

    Kind regards,

    Ricardo

  • 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