Delete the currency from a matrix-value

[Anonymous]

Hi,

I have a matrix who have prices as value, but it will show the currency within it, how can I delete that so it just shows the numbers?

Br,

[amitchandak]

@Anonymous , In the format you might have marked it as currency. check at two place

1. https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

2. Or in Column/ Measure Tools

[harshnathani · Accepted solution]

Hi @Anonymous ,

Change the formatting to decimal or Whole Numbers.

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

It depends on what's in the matrix, 

If you're using a measure, you need to click on the measure itself, then click on the "Measure Tools" Tab, then change the format to "whole number" with two decimal places 

If you have just dragged a column into the matrix, then you need to go into the data tab, click on the column name, then go to "table tools" format "whole number" with two decimal places