How To Add Currency In Power Bi

How to Add Currency in Power BI

Power BI supports various formats and styles for displaying currency values in your reports and visualizations. Here’s how you can add currency to your Power BI reports:

1. Select the visual or data field where you want to display the currency.
2. In the Visualizations pane, navigate to the Format section.
3. Expand the Values section and locate the Data type dropdown.
4. From the dropdown, select Currency.
5. Once you select Currency, additional formatting options will be available.
6. In the Currency symbol dropdown, select the desired currency symbol.
7. Specify the number of Decimal places you want to display.
8. Choose a desired Thousands separator format.
9. Click outside the Format pane to apply the currency formatting.

Here’s an example to illustrate the steps:

• Let’s say you have a visual displaying Sales Amount data.
• Select the visual or the Sales Amount data field.
• In the Visualizations pane, go to the Format section.
• Expand the Values section.
• From the Data type dropdown, select Currency.
• In the Currency symbol dropdown, choose $ for the US Dollar.
• Specify 2 for Decimal places.
• Select a desired format for Thousands separator, let’s say Comma (1,234.56).
• Click outside the Format pane to see the currency formatting applied to the Sales Amount data in your visual.

By following these steps, you can add currency formatting to any relevant data in your Power BI reports.