Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have a situation where I need some help with, I hope someone has a solution for it.
I have created a report based on a date type DD-MM-YYYY.
Sidenote:
and change this to a different format "WK"&
Solved! Go to Solution.
I solved my issue....
From PowerQuery I had transported the date as a text value and transformed the text value to a date in PowerBi desktop. which caused that in some cases the day and month where swapped.
Right now I have set the field type to date in PowerQuery and my issue is solved.
Kind Regards,
Ramon
I have a similar problem. I have a date value coming from an Azure SQL DB. I want to force a specific date format (dd.mm.yyyy) in PBI Service, so I load the dates into Query Editor and afterwards convert them into Text in Power BI Desktop. Publishing to the service gives me the right result, but when the dataset is refreshed, it changes to english format ("mm/dd/yyyy).
Why does this happen and what can I do? I really don't want to write a DAX FORMAT Measure for all my date columns! But at the moment I do not see some other solution...
I solved my issue....
From PowerQuery I had transported the date as a text value and transformed the text value to a date in PowerBi desktop. which caused that in some cases the day and month where swapped.
Right now I have set the field type to date in PowerQuery and my issue is solved.
Kind Regards,
Ramon
@amitchandak ,
Thank you for your fast response, I have checked the link and tried to setup de right settings. But it didn't solve my issue:
I have checked the PowerBi service setting its on Default (browser language)
The Chrome settings are on Englisch (UK) which should have DD/MM/YYYY
And I have cleared cache and published/ tried again.
Any other ideas?
See images bellow:
@Anonymous , Have you changed any date setting like -https://nform.com.au/how-to-change-the-date-format-in-the-power-bi-service/
Also, Clear cache and try again
or
Republish, clear browser cache, refresh and check
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |