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

jj14x's avatar
jj14x
Advocate II
9 years ago

Thanks Eno1978. CTRL + Click works in the Power Query window, but for some reason, doesn't work in the Power BI desktop application. The latter forces me to select one column at a time.

 

Advanced editor would be in Power Query as well, right? I changed the date type in Power Query - that was easy enough. But when I return to Power BI, the date format there defaults to having the weekday before the actual date.

(I am new to Power Query/Power BI, so may be overlooking something obvious)

Anonymous's avatar
Anonymous
Not applicable
9 years ago

jj14x If you are out of the Advanced Editor and working in the front end, then you have availability to expand the tables on the right  hand side, and while you can't perform the CTRL+Click, you can navigate much easier selecting the columns from that area. The main data page will jump to the column you select.

  • jj14x's avatar
    jj14x
    Advocate II
    9 years ago

    Thanks! That's a good idea.