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
Like this:
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.
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.
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 :)
Hi
We are having similar problems. There is no option for formatting English dates (dd/mm/yyyy) in the moddelling section of the ribbon..
Does anyone know how to get dates to format like this?
All our slicers are showing dates in US format where as in the tables, the dates are in UK format.
Any help would be appreciated.
Thanks
Josh
JoshSiit I am having the same issue and there is no option under the modelling tab that can let me format the date as dd-mm-yy, the closest I can find in the format is dd-mmm-yy. what's even worse is that the dates looks fine in data view but in the reports view it has time after the dates. big sigh here
I am getting the same as XLBob. no option for dd/MM/yyyy only dd/MMM/yyyy and for some strange reason it still shows as American format on the sliders.
