Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
HMB13
Regular Visitor

$ dollar sign missing

I am new to Power BI and am attempting to add the $ sign as shown in the attachment, but I could not locate the $ DOLLAR sign under modeling. Can anyone assist? How to locate it and how to add it should be listed under Fromating.

I am using the desktop version of Power BI. September 2023 release of 2.121.942.0 64-bit

 

111.jpgThank you once more.
Sam

3 REPLIES 3
pradeep_kare12
Resolver I
Resolver I

Adding a dollar sign ($) or any currency symbol to a filed power bi for formatting purposes is typically done in the Modeling or Fields pane. 

In the Filed pane, find the field that you want to format with dollor sign, This is a typically a numeric field representing a currency amount. 

 

In the PBI ribbon at the top, click on the modeling tab, this tab contains options of data modeling and formatting, In modeling you should see a format section, and you will find number formatting option in that you should see currency symbol. 

 

Here, you can specify the currency symbol you want to use. Also, by default, it's set to the dollar sign.

HMB13
Regular Visitor

thank you HotChilli it's working now.👍

HotChilli
Super User
Super User

Select the column or measure in data view.  On the ribbon at the top you will see formatting options.  There will be a dollar sign there (and lots of other currencies in the dropdown).

--

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.