Forum Discussion

dglsmason's avatar
dglsmason
Icon for Advocate I rankAdvocate 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

andre's avatar
andre
Icon for Memorable Member rankMemorable 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.

      • 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.