Lately on the Power BI Community I have noticed people having issues with the date format not showing correctly. I thought I would post the steps on how to achieve this below.
This is how my date was formatted before making the changes below
NOTE: Before starting make sure you have saved and closed all your work. I had to sign out and sign back in for the changes to take effect.
I have shown the steps to install the right language pack and have it running as the default, which will allow your Power BI dates to be displayed in the right format.
A shout out must go to ScottJackson_UK from the community who posted his initial findings which I used as a basis for this blog post.
And here is the link to his solution: Dashboard last refresh date shows in US format for users
Thanks for reading and any questions or suggestions most welcome in the comments section below.
I tried to do that, but the report still changing the original date. Actually my problem is not only the format, but the report is getting the data and changin because of the format. For example: I have a column with the date 01/02/2020 (01/feb/2020 by the original format dd/mm/yyyy in my laptop), when it is published on Power BI Service, it don't change by the format, but it changes the date - where before was 01/feb/2020 changed to 02/jan/2020... does that make sense to you? Maybe I'm not explaining correctly. I put screens on the original message so you may understand better.
Can you make sure you have the right regional settings on your Power BI Gateway Server?
Hi @GilbertQ I did all the procedures to make my PC, Google Chrome, Power BI Desktop and Power BI Web Services to have the same settings. But the problem persisted. After changing all the settings, I redid the report on Excel, and made a new Power BI report. And then, the online report was right.
Thank you for your help and tips.
Awesome @mrafael10 thanks for letting me know
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.