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

46 Replies

  • andre's avatar
    andre
    Memorable Member
    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

      This does not hold true for the Power BI browser application. If you change the format to date the date is displayed as d-m-yyyy in the Power BI desktop, but the date is displayed as Monday 1 January 2016 in a graph in your browser. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Pieter Do you have a screenshot that includes your visual and fields you are using? The format carries through to the Service with no issues on any visual for my tests.

  • RyanP's avatar
    RyanP
    Advocate II
    7 years ago

    PowerBI app sure does make this a heck of a lot more difficult than it needs to be.  Can't just set a global variable for the project to display all date fields the same?  

     

    Currenlty in PBI Desktop and battling with it in modelling. Set the format, click the chart, show data, formatting not applied....

  • cuiping's avatar
    cuiping
    Frequent Visitor
    8 years ago

    I am looking for a more flexi date formatting, instead of using long string of "Monday 13 July 2018", i would like a format as "Mon 12 Jul 18", i guess a custom format is required...so far i am not able to find any formatting icon available in Power BI yet....any one has any idea/solution to this?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi cuiping

       

      I'm looking for the exact same thing, except it's for DateTime, but functionality seems identical - did you manage a way to do that?

       

      Brgds Brian

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    is it possible to create your own custom date format?

    I dont want the full month name, but just the abbreviation of the month. 

     

    for example January 2018 should be Jan 2018, at the moment its saying (MMMM, yyyy) but can i somewhere change it to MMM, yyyy?

     

    best regards

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    How do I add a new date format?  I need to use YYYY/MM/DD and it isn't shown anywhere in the formats area.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    How do I add more formats?  I need to use YYYY/MM/DD and it isn't shown in the data modelling -> Date format section.

     

    • VFXPro's avatar
      VFXPro
      Advocate II
      7 years ago

      I have the same problem... why not allowing true custom date format where we can type d, MM, YY etc...?

      I need for have "Mon, Oct 14,'18" and such option is not availble :(

       

      Is there a trick to create a custom display format?  I know I could create a custom column, but I have so many date columns it would take a while...  If I could simply customize the "display view" of such column to the date and time format I need, it would be perfect.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Experts,

     

    My data source have the formart of dat/time/timezone and same in power query but when i look in datview tab i can able to see onlt date/time can you please tell me how to change it to date/time/timezone format.

  • lax's avatar
    lax
    New Member
    7 years ago

    Another option will be to use below formula

     

    Create a custom column as below

     

    formattedDate= RAW[OrderDate].[Year] &"-"& RAW[OrderDate].[MonthNo] &"-" & RAW[OrderDate].[Day]

     

    Make sure you convert the source column to date-time data type

  • lax's avatar
    lax
    New Member
    7 years ago

    Another option which I discovered while trying to deal with this issue is using the below DAX function

     

    Create a new Custom Column (formattedDate below)

    formattedDate = RAW[OrderDate].[Year] &"-"& RAW[OrderDate].[MonthNo] &"-" & RAW[OrderDate].[Day]

     

    Where OrderDate is your original column

     

    Make sure you convert OrderDate to DateTime Column.

     

    PS: I realize, I'm replying to an old post but hoping it help others

    • RyanP's avatar
      RyanP
      Advocate II
      7 years ago

      Cannot be used with the variation 'Year' because it does not have any...

       

      Its a Date/Time field...

  • davebrown89's avatar
    davebrown89
    Frequent Visitor
    7 years ago

    I'm running into a similar issue when using direct query to a SQL table.  The information is properly cast as 'date' within my source table and is rendering fine in the power query editor.  However when I view these date fields in a table (or any visual) it is automatically changing it to the long format with no option to shorten.  

     

    Supporting images here:

    https://imgur.com/a/Qfsg9Oe

     

    I've checked my regional settings and everything is set to the US.  Am I missing something that would preserve the date format (MM-DD-YYYY) that's in my data set rather than PowerBI converting it to (Day of Week, Month DD, YYYY)??