Forum Discussion

puneethjp's avatar
puneethjp
Helper II
2 years ago
Solved

Date format changes after publishing the report.

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's avatar
    Anonymous
    2 years ago

    Hi puneethjp ,

    One possible solution is to change the language settings in Power BI Service to match the language settings in your browser.
    If this solution doesn’t work, you can try changing the date format in Power BI Desktop before publishing the report.

    How to Change Date Format in Power BI - Zebra BI

     

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details.

     

    Best Regards
    Community Support Team _ Rongtie

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

     

     

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi puneethjp ,

    One possible solution is to change the language settings in Power BI Service to match the language settings in your browser.
    If this solution doesn’t work, you can try changing the date format in Power BI Desktop before publishing the report.

    How to Change Date Format in Power BI - Zebra BI

     

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details.

     

    Best Regards
    Community Support Team _ Rongtie

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