Forum Discussion

DemoFour's avatar
DemoFour
Icon for Continued Contributor rankContinued Contributor
5 years ago
Solved

date format now showing Day name

Hi All,    My published reports are changing the date format to show the day month month number year e.g. Saturday October 01 2016   In Desktop they are set to Long date e.g 01 October 2016   H...
Need Help
  • DemoFour's avatar
    DemoFour
    5 years ago

    Morning v-robertq-msft 

    Thanks for your response, that is exactly what I did. I had a play with the date format and discovered that if you choose the lower versions and not the top version Long and Short, that it worked the way I wanted it to. 

    Refreshing the report and checking the output each time.

     

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, 

According to your description, you said that your date format is too long to mess up your visuals when published to the Power BI service.

I think you can simply solve this problem by changing the date format to the short type like “yyyy/mm/dd” in the Power BI Desktop and publish the report again the overwrite the original report, and the date format will be changed to the short type.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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

  • DemoFour's avatar
    DemoFour
    Icon for Continued Contributor rankContinued Contributor
    5 years ago

    Morning v-robertq-msft 

    Thanks for your response, that is exactly what I did. I had a play with the date format and discovered that if you choose the lower versions and not the top version Long and Short, that it worked the way I wanted it to. 

    Refreshing the report and checking the output each time.