Forum Discussion

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

Anonymous

Not applicable

9 years ago

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

Regards,
Lydia Zhang

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