Forum Discussion

mutrax's avatar
mutrax
Regular Visitor
5 years ago

Using ISO format in date slicer

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
mutrax
Regular Visitor
5 years ago

Hi Anonymous  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.