Forum Discussion
Date Display Formats
click on the time field in your model then you can click on Modeling in the Desktop ribbon and pick the desired date format
Pieter Your screen grab shows the "Query Editor" - after you "close & apply", click on "Modeling" in the header. Under the "Formatting" header do you have "Data Type: Date" and a selected format?
This is the model layer, you need to explicitly define the format there as well.
Thanks a lot Anonymous, that helped.
Not very intuitive though.
Is there a way to set the default date format in the desktop application?
In Power Query, I can select all the date fields at one time and apply the date format to all together.
In the Desktop application however, I can only select one column at a time, change it, (which will make the view shift all the way to the first colum), scroll over to the next column, select, change it, and repeat.
Very tedious for some of the larger datasets that are filled with date columns :)
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)
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.
Pieter Think of the Desktop as 2 different environments. When you load data you are using "Power Query" to do the ETL. Then after you "Close & Apply" the data is loaded into a Tabular Model. Much in the same way you would do checks and format things in the Tabular model, you still need to verify and validate correct format there as well.
Glad it works.
jj14x I'm not aware of the way in which you could manually update the M code, but there is most certianly a way in the Advanced Editor. Otherwise, if you are stuck to the UI, a quicker way to get all the columns at one time is to select a column and CTRL + Click any additional columns that will be changed to the same format. All of them will highlight and you can then select your format.
Thanks! That's a good idea.
