The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to Solution.
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
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