Forum Discussion
Delete the currency from a matrix-value
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,
- Anonymous6 years ago
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)
3 Replies
- AnonymousNot applicable
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
- amitchandak
Super User
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
- AnonymousNot applicable
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)