Hi
We are an Irish Company and our date format should be DD/MM/YYYY as oppossed to the American way of MM/DD/YYYY
When i format dates etc on Power Bi Desktop they are correctly shown as DD/MM/YYYY (see snip below)
But when it is shown on Power Bi Service and Shared to users as an App it changes to the American Format - see SNIP Below
How can i fix this?
Solved! Go to Solution.
Hi. The dates management can be really tricky. The thing is that those default formats like you are showing will change automatically to response on the Browser Language. Each account can configure on Power Bi Service if you want to use default browser language region to render reports or set one as default.
I'm not sure if you can change that for a file. I think that's when you create it. However you can try setting a regional date type on Power Query (Transform data or quey editor menu) as sfrost shows there.
Let's see if that definition can stay in the browser configuration in Service.
Hope that helps,
Happy to help!
Hi. The dates management can be really tricky. The thing is that those default formats like you are showing will change automatically to response on the Browser Language. Each account can configure on Power Bi Service if you want to use default browser language region to render reports or set one as default.
I'm not sure if you can change that for a file. I think that's when you create it. However you can try setting a regional date type on Power Query (Transform data or quey editor menu) as sfrost shows there.
Let's see if that definition can stay in the browser configuration in Service.
Hope that helps,
Happy to help!
Try the following steps to remedy that.
Did I answer your questions? Give a thumbs up and accept this post as solution!
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!