Date type

[Marcin]

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. 

[Anonymous]

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]

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]

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]

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]

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

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 . 

[Anonymous]

@Marcin,

You can submit an idea in this forum: https://ideas.powerbi.com/forums/265200.

Regards,

[Anonymous]

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.