Dynamic date formatting based on user's browser language

[TSzreder]

Hi all,

I am supporting one of the clients that wants the date in his report to change formatting based on the user's browser language.

Theoretically this should be possible by using one of the date formats with an asterisk (*), however this does not work.

I use Polish as my locale, so the asterisk format is dd.mm.yyyy and after the publishing and changing browser language to English US, I would expect it to change to mm/d/yyyy but the format stays as dd.mm.yyyy

Any idea on how to make it work?

[v-yalanwu-msft · Accepted solution]

Hi @TSzreder , 

Because your yellow mark is the general date format, and red is the custom date, so when you change the language, only the language difference will be displayed, and the format is custom/fixed. If you want to achieve dynamic language, you can try to use slicer or set in power query：

Slicer way1:

1.Enter table as language slicer

2.Create a measure

Measure =
SWITCH (
    MAX ( 'Slicer'[language] ),
    "Polish", FORMAT ( MAX ( [Date] ), "dd/mm/yyyy" ),
    "US", FORMAT ( MAX ( [Date] ), "mm/d/yyyy" )
)

The final output is shown below:

Power query way2:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau]

Hi. You are right about the (*) and behaviour. Please be sure that you have configured your browser properly and the general settings in the workspace is reading language as default:

You can get there clicking dataset Settings and change tabs.
That should work. I have my PBI Desktop in Spanish and my browser in english. I can see the difference in dates formats everyday.

I hope that helps,

[TSzreder]

Thanks @ibarrau !

I checked that the setting is correct but it still doesn't work with dates... 

However, it works with datetime column, the one I have marked with yellow but the one in red still doesn't work...

Unfortunately that doesn't really solve my problem as I don't need the time part...