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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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,

 

1 ACCEPTED SOLUTION
harshnathani
Community Champion
Community Champion

Hi @Anonymous ,

 

 

Change the formatting to decimal or Whole Numbers.

 

1.jpg

 

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

View solution in original post

3 REPLIES 3
amitchandak
Super User
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

Data Format New Rib.png

 

 

harshnathani
Community Champion
Community Champion

Hi @Anonymous ,

 

 

Change the formatting to decimal or Whole Numbers.

 

1.jpg

 

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

Anonymous
Not 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 

Karlos_0-1597660953897.png

 

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 

 

Karlos_0-1597661086386.png

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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