Date format changes after the file is publishing it to PBI services.

[puneethjp]

Hi, 

The date format is changing after publishing the report. 

In destop: (before publishing). 

In Service After publishing. All week end date shows up as saturday only. 

The three filelds used: 

Year = Text
Month = Text ( Measure = 

Month =

 SWITCH((Dim_Date[nielsen_period_month]),1,"Jan",2,"Feb",3,"Mar",4,"Apr",5,"May",6,"Jun",7,"Jul",8,"Aug",9,"Sept",10,"Oct",11,"Nov",12,"Dec")

Week_ending_date  format = 14 march 2001( Long date)

Appreciate your help. 

Thanks

Puneeth

[Anonymous · Accepted solution]

Hi @puneethjp ,

May I ask if you have solved your problem?
The date format is displayed differently for different regions, this should be caused by the region setting in Desktop not matching the language setting in Service.
Please check the Regional Settings in Desktop and Language settings in Service, make sure they are consistent.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

The format is based on the report user's locale settings. If you don't like that, use text representations.