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 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 !!

 

Need Help

5 Replies

    • mutrax's avatar
      mutrax
      Regular Visitor
      5 years ago

      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.  

  • 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.

  • adityakumar619's avatar
    adityakumar619
    Helper II
    4 years ago

    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.