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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Visual showing showing local currency inspite of different formatting

Akshay45___0-1701187236625.png

I have a measure to switch between sales and quantity. Quantity is formatted in whole number and sales is in $ currency.
when i switch between them in a visual like matrix as above,they are showing in local currency ruppees.
please help me to fix this error.

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

vicky__0-1701209715250.png

Click the down arrow next to the $ sign in the format and you should be able to change the symbol next to the currency. Or, you can write a custom format string with the FORMAT() function. https://learn.microsoft.com/en-us/dax/format-function-dax

View solution in original post

1 REPLY 1
vicky_
Super User
Super User

vicky__0-1701209715250.png

Click the down arrow next to the $ sign in the format and you should be able to change the symbol next to the currency. Or, you can write a custom format string with the FORMAT() function. https://learn.microsoft.com/en-us/dax/format-function-dax

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors