Forum Discussion

Sean-OReilly's avatar
Sean-OReilly
Helper IV
5 years ago
Solved

Help to Change Date Format on Power Bi Service

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...
Need Help
  • ibarrau's avatar
    ibarrau
    5 years ago

    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,

_sfrost's avatar
_sfrost
Solution Specialist
5 years ago

Sean-OReilly 

Try the following steps to remedy that.

  • Open your PBIX file > Go to Transform Editor (Power Query Editor)
  • Select the Date Column > Right Click on Column Name> Change Type > Using Locale

  • Once you click on Using Locale, a window pops-up with the below options

  • Change Data Type to Date or DateTime and Locale to your desired locale type
  • And click on OK and apply the transformations and publish to service

 

Did I answer your questions? Give a thumbs up and accept this post as solution!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    _sfrost thanks a lot ! Your solution was the one that helped me.