How To Add Dollar Sign In Power Bi

by

How to add dollar sign in Power BI

To add a dollar sign in Power BI, you can use the “Format” option in the Power BI Desktop. Here’s a step-by-step guide on how to do it:

  1. Open your Power BI Desktop and load the data you want to work with.
  2. Select the desired visual (chart, table, etc.) where you want to add the dollar sign.
  3. From the Visualizations pane on the right, locate the “Fields” section.
  4. Find the column that you want to format as currency (that needs the dollar sign).
  5. Click on the column name to select it.
  6. In the “Modeling” tab at the top, locate the “Formatting” section. If it’s not visible, click on the “Format” icon (paint roller) in the toolbar.
  7. Under the “Category” dropdown, select “Currency”.
  8. Enable the “Symbol” checkbox.
  9. In the “Symbol” field, enter “$” (without quotes) to specify the dollar sign.
  10. Adjust other formatting options as per your requirements (e.g., decimal places, thousands separator, etc.).
  11. Observe the visualization to see the dollar sign added to the column.

For example, suppose you have a column named “Revenue” that contains sales data. By following the steps above and setting the format as currency with a dollar sign, the column will display values like “$10,000”, “$5,678.90”, etc.

Using the convenient formatting options in Power BI, you can easily add the dollar sign to your visuals and customize the display of currency values according to your preferences.

Leave a comment