Add $ currency to Measure values

[Anonymous]

Hi All,

 looking for solution for below requirment.

I have a column with values for both count and currency(in single column). i will display currency values in a card using measures. Now in card when i drag the measure i want to show $ symbol for value. 

Someone please help me out to achieve this.

TIA

[amitchandak · Accepted solution]

Better you a measure for one of those. Else you need to use format option under visualization.

Create a measure and set it as a currency

[Syndicate_Admin]

Hello! If a card does not show the data as currency, you can go to the Data section, click on the name of the column, at the top the menu of Column Tools is enabled and there it gives you the option to change the format to currency

Leaving in the configuration of the balloon of the card, in show units you put none and the data already appears as a value in currency

I hope it has fixed your issue, slds.

[v-chuncz-msft · Accepted solution]

@Anonymous 

Take a look at Display custom format strings to learn more.

[amitchandak · Accepted solution]

Better you a measure for one of those. Else you need to use format option under visualization.

Create a measure and set it as a currency

[luapdoniv]

Can you not just format the column to use $ Currency and then use it in the card.
For the count, just use the count, instead of sum and the $ won't come.

For a better understanding of your problem please share relevant screenshots and sample data.