Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Tahreem24
Super User
Super User

@Anonymous ,

 

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!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Anonymous
Not applicable

@Tahreem24 

 

Thanks, but here it doesn't

 

R.W.

amitchandak
Super User
Super User

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/...

 

Pragati11
Super User
Super User

Hi @Anonymous ,

 

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Anonymous
Not applicable

Thanks,

 

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

 

Region_Settings.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

R.W.

Hi @Anonymous ,

 

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Anonymous
Not applicable

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.

HI @Anonymous ,

 

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

 

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

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Anonymous
Not applicable

@Pragati11 

 

Thanks,

 

but it is

 

Region_Settings2.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

R.W.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.