Power BI Data Culture

Hello Kealkil42023 - 

• The model's regional settings will either match your Windows setting or a different one manually selected in the drop-down.
• The culture for which the model is applied when consumed by a user is controlled in PowerBI desktop in the Current File Regional Settings and in Excel with it's own regional setting (see steps below).

• If you are not seeing English (Ireland) as an option for you in Windows, you an try to add it:
  • If a user doesn't see the Windows regional option of English (Ireland), they can follow these steps to add it:
  • Open Settings: Press the Windows key + I to open the Settings app.
    Time & Language: Click on "Time & Language" and then select "Region & Language".
    Add a Language: Under the "Languages" section, click on "Add a language".
    Select English (Ireland): Scroll through the list and select "English". Then, choose "English (Ireland)" from the list of English language options.
    Set as Default: Once English (Ireland) is added, click on it and select "Set as default".
    Restart Your Computer: Restart your computer to apply the changes.
    If the option is still not available, it might be due to the version of Windows being used or regional restrictions. In such cases, users can try the following:
  • Control Panel: Open the Control Panel by pressing Windows key + R, typing "control", and pressing Enter. Go to "Clock and Region" > "Region" > "Administrative" tab > "Change system locale" and select "English (Ireland)".
    Update Windows: Ensure that Windows is up to date. Sometimes, regional options are added or updated in newer versions of Windows.
    Language Pack: Download and install the language pack for English (Ireland) from the Microsoft website or through Windows Update.
• To set the regional settings for Power Query in Excel, follow these steps:
  • Open Excel: Launch Excel on your computer.
  • Go to Options: Click on File in the top-left corner, then select Options.
  • Query Options: In the Options window, navigate to Data > Query Options.
  • Regional Settings: Under Current Workbook, select Regional Settings. 
    • https://support.microsoft.com/en-us/office/set-a-locale-or-region-for-data-power-query-d42b9390-1fff-413f-8120-d7df0ced20b9 

• You can also ensure that dates are formatted and presented as DD/MM/YYYY, by using the Format function in Power BI. For example, you can create a new column in your data model with the following DAX expression:

  FormattedDate = FORMAT([YourDateColumn], "dd/mm/yyyy")