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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
ssze
Helper II
Helper II

Date format in slicer (to show dd/mm/yyyy)

Hi all!

It seems like a topic that has been asked so many times but i haven't been able to get it to work yet unfortunately!

 

I have on my powerBI desktop a daterange slicer which displays in the dd/mm/yyyy format perfectly.

ssze_0-1599074021191.png

once published though the slicer date reverts back to the mm/dd/yyyy format again.

ssze_1-1599074066618.png

 

I have tried changing the actual data format

ssze_2-1599074185714.png

and the computer location setting (date time and regional settings) seems correct

ssze_3-1599074255725.png

 

and lastly my chrome setting is also set to the dd/mm/yyyy way as well

ssze_4-1599074326238.png

 

what else can I try? Have tried to trawl through community posts and responses already.

thanks in advance!

 

Silvia

 

 

18 REPLIES 18
orbe
Advocate I
Advocate I

Hi,

I add the idea for microsoft to fix. please vote

The idea:  Apply date format "DD-MM-YYYY" in filter between

link : https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=df130c22-c95e-ef11-a4e6-000d3a7b101f

Dhananjay_Walun
Frequent Visitor

Hi All,

I recently faced the same issue and applied the following solution:

To view the dates in UK style, you need to adjust your browser settings.

For Chrome Browser:

  1. Go to Settings.
  2. Navigate to Languages.
  3. Click on Add Languages.
  4. Select 'English (United Kingdom, Oxford English Dictionary spelling)'.
  5. Click on the kebab menu (three vertical dots) next to the language and choose 'Move to the top'.

For Edge Browser:

  1. Follow the same steps as above. (Only the menu icon is different)

After updating your language settings, refresh the dashboard page.

I am sorry, but this is not a "solution". This is "giving up".

The question here is to keep the browser settings (because we do use browsers for other things too...) and still be able to control the format in Power BI artifacts.

JonathanSpencer
New Member

None of the suggestions worked as above, Our report is sitting in a workspace on PBI Web version, Please point me to the thread where I can request a change.

j_kee
Frequent Visitor

Even after all this time, this issue persists.

I have a nagging feeling this is nothing but a bug. The "Between" setting of a date slicer appears to not respect the format of the field, whereas the "Dropdown" setting does.

 

It is seriously annoying that Micosoft doesn't support people using English as their professional language while still preferring to adhere to local culture. The ambiguity stemming from "what do you mean by 3/2 2024?" is just too big a problem to be ignored for this long.

Anonymous
Not applicable

It's really not a solution to have to fiddle with region settings. A solution was for the application (Power BI) to accept a given format and stick to that.

mcc1
Regular Visitor

Hello, 

Did somebody find a solution? I have the same problem and already saw all the suggested above and the format is still mm-dd-yy

Swati20
Frequent Visitor

Hey, 
Did you find any solution? 
As changing the language settings in browser will work for me only and not for others untill they also change their language settings. And I can't ask each any every user to change their browser settings.

JamesBowdidge
Frequent Visitor

Hi,

 

I know this is old, but you ever get this resolved I have the same issue.. all settign correct.. but published slicer date format mm/dd/yyyy..

 

thanks

 

J

Anonymous
Not applicable

Hello,

I've managed to resolve this on my end by changing the Chrome language settings, then removing English(United States) from preferred languages.

 

SamPo_1-1698988122782.png


Hope that helps

 

FrankAT
Community Champion
Community Champion

Hi @ssze 

  1. Open Model view and select the date column.
  2. Open Properties pane and change the data type to Custom.
  3. Your format should read: dd\/mm\/yyyy.

In some resons the slicer doesn't reflect the new format. In this case delete the existing slicer and create it new.

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

Thank you! But also still no 😞

The column is already in the Date type and date format you recommended.

I also deleted the slicers and then reinserted again.

Any other suggestions? 🙂

ssze_0-1599091925098.png

Hi @ssze ,

 

When you view the report in Power BI service, the slicer date formats decided by browser language. Would you please change the language of chrome by:https://gadgets.ndtv.com/internet/features/how-to-change-language-in-google-chrome-1871519 For IE, please refer to https://answers.microsoft.com/en-us/ie/forum/ie9-windows_7/how-to-change-language-internet-explorer-...

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

 

Anonymous
Not applicable

That's really not helpful when you want to have english as the language of your windows, application, browser etc, but you want a sensible date format like yyyy-MM-dd and not be forced based on region settings.

Greg_Deckler
Super User
Super User

@ssze - What about your Windows 10 regional setting?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

hi @

I went here:

ssze_1-1599076488211.png

and checked:

ssze_0-1599076420804.png

is this the one you are referring to?

Check once your PBI desktop  file's regional setting:

Go to File > Options > Options and settings > Current File >Regional Settings.

 

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

This one is also already in NZ too - i also tried UK but still same when published. 😣

ssze_0-1599080541872.png

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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