Forum Discussion

Marcin's avatar
Marcin
Helper V
9 years ago

Date type

Hi,

 

I have this problem that in some reports the date filter shows format as US  ( MM-DD-YYYY) . My regional settings in Power BI Desktop are correct, on my computer also eventrtnhing looks like YYYY-MM-DD. 

 

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Have a look at the underlying Date data and its format.  I'm always wrestling with the Data formatting of most microsoft products.  Here in AUS we use DD/MM/YYYY.  Sometimes i've had MS programs invert the DD/MM to MM/DD and often my solution is just to put my own data format inversion back in.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Marcin,

    Click on your date column in Fields Pane, then change its format to yyyy-MM-dd under Modeling ribbon.


    Regards,
    Lydia Zhang

    • Marcin's avatar
      Marcin
      Helper V
      9 years ago

      Hi Anonymous

      Unfortunately I am using data from SSAS with Live Connnection so I can't change this format in PowerBI desktop.  

       

      I forgot to add that the format date is changing after I publish my report to Power BI service. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Marcin,

        I am not able to reproduce your issue in the latest version of Power BI Desktop (2.46.4732.721), please check the region settings in my environment. I change regional setting in my computer and change regional setting to Polish(Poland) in Power BI Desktop, after I re-open Power BI Desktop file, everything works well.


        In addition, after you publish Power BI Desktop file to Power BI Service, the date format will change based on the language settings in Power BI Service.


        Regards,
        Lydia Zhang