cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RudyWelvaert Helper IV
Helper IV

Format dates in slicer not as expected

Hi, 

 

I have a date dimension table D_DATE that contains the field BK_Date that contains a date.
Its format is set to dd/MM/yyyy

 

Date_Slicer_02.png

 

 

 

 

In the facts table F_METRICS I have a calculated field Datum = RELATED(D_DATE[BK_Date])based on the corresponding value of BK_Date from the D_DATE table.

The format of the field Datum is also set to dd/MM/yyyy

 

Date_Slicer_02.png

 

 

 

 

The calculated field Datum is used in a slicer:

 

Date_Slicer_01.png

 

 

 

 

But the format of the two dates shown in the slicer is M/d/yyyy instead of dd/MM/yyyy.

How can I force the slicer to use the format of the field calculated Datum and the related field BK_Date?

 

Thanks

 

R.W.

 

9 REPLIES 9
Pragati11 Resident Rockstar
Resident Rockstar

Re: Format dates in slicer not as expected

Hi @RudyWelvaert ,

 

Can you please check the date format of your system/machine on which Power BI Desktop is installed?

I think your system date format is MM/DD/YYYY, therefore slicer is showing it that way in Power BI.

 

If this helps please give Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

Super User IV
Super User IV

Re: Format dates in slicer not as expected

The date should follow the format on the base field. DD/MM/YYYY format is governed by the format of the system. Make sure that is done. Also when you are seeing it as DD/MM/YYYY is date format.

Refer

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/...

 





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


RudyWelvaert Helper IV
Helper IV

Re: Format dates in slicer not as expected

Thanks,

 

But my settings are correct, namely dd/MM/yyyy

 

Region_Settings.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

R.W.

Pragati11 Resident Rockstar
Resident Rockstar

Re: Format dates in slicer not as expected

Hi @RudyWelvaert ,

 

I see in your screenshot, that your Format = English(Belgium). Is this right? Does this need to be chnaged to United States or United Kingdom, etc.?

 

Also, try checking in Power BI settings as follows:

date1format.png

This should be same to your system date settings Region.

 

If this helps please give Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

Super User II
Super User II

Re: Format dates in slicer not as expected

@RudyWelvaert ,

 

I have made same changes at my end and it is working perfect.

Capture.JPG

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

Don't forget to give thumbs up and accept this as a solution if it helped you
RudyWelvaert Helper IV
Helper IV

Re: Format dates in slicer not as expected

Thanks,

 

yes this is OK

I'm working in Belgium, using Belgian key board, but all the applications are in English

So English (Belgium) is correct

 

I tried to change it to United States and in United Kingdom, but it doesnt have any effect: the dates in the slicer stay in the wrong format

 

R.W.

 

R.W.

Pragati11 Resident Rockstar
Resident Rockstar

Re: Format dates in slicer not as expected

HI @RudyWelvaert ,

 

Does your Power BI settings also use "Belgium (English)" ??

 

If this helps please give Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

RudyWelvaert Helper IV
Helper IV

Re: Format dates in slicer not as expected

@Tahreem24 

 

Thanks, but here it doesn't

 

R.W.

RudyWelvaert Helper IV
Helper IV

Re: Format dates in slicer not as expected

@Pragati11 

 

Thanks,

 

but it is

 

Region_Settings2.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

R.W.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors