Date slicer needs to be able to use regional formats

[jc508]

I have database column [Ordered Date] of type Date
when used in a Slicer visualisation in Power BI Desktop it displays correcly im my regional settings (dd/mm/yyyy)
However when published it changes to american format mm/dd/yyyy
I cant find any way to alter this behaviour. Other posts suggest it is a browser dependant issue but I see the same results in Firefox, Edge, IE
 

Any suggestions ?

Thanks JC

[rdeh71]

Does anyone know a fix for this yet ? Our report users are non technical and getting them to fiddle with browser settings is not an option.  

I am finding that the date format is altered to US on the desktop now as well. The underlying data is showing UK, the settings in the options for the report is showing english uk, but the slicer still shows US dates.  This actually is a serious bug as users will be misreading the dates....

[v-yulgu-msft]

Hi @jc508,

In Power BI Desktop, it takes the date format of local machine.

In Power BI service, it takes the date format of language setting in browser. You can change the language in your browser and then setting the Power BI Service language to default.

Here is a similar thread for your reference: Date format changing desktop to web

Best regards,
Yuliana Gu

[jc508]

Thanks Yuliana

unfortunately this doesn't work for me. 

Edge has no defalt language and uses the computers setting (Australian)

Firefox is set to English (en)   ie not to US

but the slider still shows US format dates in the BI Service

JC

[GilbertQ]

Hi @jc508

What if you change the format of your date column when using DAX

Another option is to ensure that your IE language settings are set to Australian?

format([Ordered Date], "dd/mm/yyyy")

[jc508]

Hi,

Changing the format actually makes it a text column (not date) so the slicer loses its slider bars 😞

I have to do this in the 'cube' as when using SSAS data there is almost nothing that can be changed at presentation (power-Bi) end

I just tested Chrome and it behaves properly - then went back and explicitely added 'English / Australian' to firefox and now it works too.  (so who knows what genereric 'English' actually meant - it was listed differently from 'English US' ??)

So thanks to all its fixed except I have to get all my users to fiddle with their broswer settings.

JC