web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Default Power BI repor...
Small and medium business | Business Central, N...
Suggested answer

Default Power BI report currency to USD instead of local currency

(2) ShareShare
ReportReport
Posted on by Janarthanan Varadha... 33 
Hi everyone,
I’m currently working with Power BI reports that are deployed across different regions. By default, the reports pick up the user’s local system currency or region settings. However, I want to force all currency values to display in USD ($) regardless of the user's locale.

My question:

  • Is there a way to set USD as the default currency for the entire report or dataset?
  • Can this be controlled via Power BI Desktop, Power BI Service, or through DAX formatting?
  • Are there any best practices for handling currency conversion and display in multinational reports?
Any guidance or examples would be greatly appreciated!
Thanks,
Jana
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 23,590 Most Valuable Professional on at
    Default Power BI report currency to USD instead of local currency

    Hi, good day

    Select the [Sales Amount] field, go to the Modeling pane in Power BI, and in the format, choose Currency ($).

    Best Regards
    Gerardo

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,389 on at
    Default Power BI report currency to USD instead of local currency

    Hi Jana,

    Great question! To ensure your Power BI reports consistently display currency in USD ($) regardless of the user's locale, here are a few approaches you can consider:

    1. DAX Formatting: You can use DAX to format your currency fields explicitly in USD. For example

    FORMAT([Amount], "$#,##0.00")

    1. This forces the display to USD formatting, but note that it doesn't handle currency conversion—only formatting.

    2. Currency Conversion Table: If your data includes multiple currencies, it's best practice to create a currency conversion table with exchange rates and apply the conversion in your data model. You can then calculate and display all values in USD.

    3. Power BI Desktop Settings: While Power BI Desktop respects the system locale, you can override this by setting the model culture in the report settings. However, this affects formatting, not conversion.

    4. Power BI Service: The service also respects the browser or system locale. To maintain consistency, it's best to handle formatting and conversion within the report itself using DAX and data modeling.

    5. Best Practice: Always separate raw values from converted values and clearly label them. This helps avoid confusion and ensures transparency in multinational reports.

    Let me know if this helps!
    If it solves your issue, please mark this answer as accepted so others can benefit too. 😊

    Best regards,
    Daniele

  • Suggested answer
    Andrés Arias Profile Picture
    Andrés Arias 4,164 Super User 2025 Season 2 on at
    Default Power BI report currency to USD instead of local currency
    Hello,

    The recommendation would be to perform the necessary conversion or adjustment (DAX) in Power BI Desktop to verify and validate the currencies and exchange rates that have been used.
     
    As primary data, you should always look at the date of entry, currency, and amount of each transaction.
     
    I hope this helps.
     
    Regards,
     
    Andrés

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,568

#2
Sumit Singh Profile Picture

Sumit Singh 2,536

#3
YUN ZHU Profile Picture

YUN ZHU 2,015 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans