Forum Discussion
Measure shows different format and date value after published and refreshed in service
Hey,
I have had similar issues with dates.
I would check that in desktop the Invoice_Posting_Date is of data type 'Date'.
Check the original source data for this, is the data all in consistent date format(Use power query editor).
I would also use power query editor to transform that column so that the format is in more standarised for a date - would get rid of '.' and the space to a '/' -
You can use transform data, go to column, under transform tab click replace values and change the period space to /
Also in power query (Click transform data in desktop) make sure that data type for that column is 'Date' - this is found under transform tab.
A few things to try, my desktop is all in english so hopefully this makes sense for hungarian too.
Let me know if any help 🙂
Hi freidav1984 ,
Please have a try.
The issue is caused by a combination of the settings in the Power BI Service and the settings in your browser.
-
Click on the gear icon in the top right corner
-
Click on Settings
-
Select Language
-
Select Default Browser Language
-
Go to the Browser Settings
-
Search browser setting for “Language”
-
If your correct language/region is not shown select add language
-
Select the 8 vertical dots next to the language you want to be the primary language
-
Choose Display Google Chrome in this Language
-
Go back to Power BI and refresh your report/dashboard
More details:How to change the date Format in the Power BI Service | NFORM | Perth, Australia
If it still does not help, please provide more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.