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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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