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 ...
Need Help
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

  • Marcin's avatar
    Marcin
    Helper V
    9 years ago

    When I change language settings in Power BI service from English to Polish ( Polski ) then format is correct : 

     

    With English language selection is changed again, In my opinion there should be option like "US English " 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Marcin,

      Has the issue been solved? To make the date display as YYYY-MM-DD, you would need to change language setting to Polish(Polski).

      Regards,
      Lydia Zhang

      • Marcin's avatar
        Marcin
        Helper V
        9 years ago

        Thanks for help, unfortunately I am using english language in all of my applications so I will wait for next preview where will be ability to choose two types of english formats .