Using ISO format in date slicer

[mutrax]

Hi,

I have this field DateOpen that's defined with the "YYYY-MM-DD HH:MM" format in the dataset.  When the field is displayed in a table or a card, it appears with the right formatting.

However, I also use this field in a date slicer and when published to the Web Service, the slicer will display the min/max dates using the browser's local standard.  So, for some user it will be "DD/MM/YYYY"  and for other users it will be "MM/DD/YYYY". 

Is it possible to 'force' the date slicer to use the ISO format as defined in the dataset, regardless of the local date/time format of the client ?

Thanks !!

[adityakumar619]

Do we have any possible resolution for this issue as i can see so many Powerbi Users faces this senario?

Let us know if anyone has better solution for this.

[v-rzhou-msft]

Hi @mutrax 

I think your problem is that show different date format in Power BI Service.

The issue is caused by a combination of the settings in the Power BI Service and the settings in your browser. 

You can try to use Chrome as your browser.

For reference: How to change the date Format in the Power BI Service

Make all users in the same browser language in Chrome.

If you need "YYYY-MM-DD", you can change the date format as "yyyy/m/d" in column tool in Power BI Desktop directly.

Best Regards,

Rico Zhou

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

[mutrax]

Hi @v-rzhou-msft  and thanks for your suggestion.  This works for the date displayed in a table or other visuals.  However, the date slicer don't take in account the chosen format, it uses by default the browser's local.   So, if the browser local is English, it will display "mm/dd/yyyy", if it's French, it will display "dd/mm/yyyy".  We'd like to display "yyyy-mm-dd" and that's how it's defined in the dataset.

[amitchandak]

@mutrax , I have not tested this, but if force format here, it should use that format. and should not use default format

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

[mutrax]

Hi amitchandak and thanks for your suggestion.    I tried the Custom date format as described in the article using "yyyy-mm-dd" and still, it shows the date using that custom format in cards and tables but the slicer still uses the default browser "local" formatting.