Date Display Formats

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

Anonymous have you updated to the latest version? the issue went away after upgrade

Hi

I've realised it was a problem with the February update. So I rolled back to the previous build and the problem went away.

Anonymous upgrage to the March release, it should fix your problem

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.

Hi XLBob

I am currently on Version: 2.55.5010.641 64-bit (February 2018)

which Version are you using?

Hi

I've realised it was a problem with the February update. So I rolled back to the previous build and the problem went away.

ok i will raise a request to update it,

cheers for your time and support.

I'm still strubbling with Date Formats...

I'm getting mm-dd-yyyy in my PBI visuals.

Source column is from sql server db and set to date

I want dd-mm-yyyy

So what are the correct steps to realize this?

BTW

- tried setting my PBI.com settings to Dutch(Netherlands) --> Dutch = dd-mm-yyyy --> NOT HELPING

- tried setting my PBI Desktop settings to Dutch --> NOT HELPING

Hi

The latest update to Power BI seems to have fixed this issue. Once I updated, the English date and time formats reappered.

Thanks

Josh

Hi

The latest update to Power BI seems to have fixed this issue. Once I updated, the English date and time formats reappered.

Thanks

Josh

I don't want the English format (mm-dd-yyyy) ... I want (in a aesy way) the Dutch format (dd-mm-yyyy)...

And that seems hardly impossible without doing something code-base-like

The English and Dutch formats are the same (dd-mm-yyyy).

(mm-dd-yyyy) is American.

Have you got the latest version of Power BI?

I've got March 2018 version for PBI Desktop...

But still... could you explain the least possible steps to change the Englisch format to the Dutch format?

Hi, update to the April version and the format you want will be available. That should be the only step.

You can Download the latest version here 

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2018-feature-summary/

Hi JoshSiit (and bobsel),

I have also the latest Power BI Desktop version of April, but I see still the US formats. I think this has something to do with your OS language. What is your language setting over there? 

I have read this blog about it:

https://superfarb.com/power-bi-customising-date-format/

Thanks in advance.

Kind regards,

Ricardo

Hi

The language setting we have is English (United Kingdom).

Hi JoshSiit,

I changed the OS language to English (United Kingdom) as well and now it works! The original setting was English (United States).

Example 1: Language English (United States) - default 

Example 2: Language English (United Kingdom)

So bobsel, this is the quickest way to get your Dutch format. Otherwise (if you leave the language on United States), you can do something like this:

Unfortunately, this will convert your date into text and then you will lose built-in date functionality like Date Hierarchy.

Kind regards,

Ricardo

This was most likely fixed in newer versions ... Slicers show correct format for dd-MMM-yy