Scorecard Visual - stop numbers rounding to K or M

[PowerBIWhat]

I've built a scorecard visual which has a metric where the value is currency £. I want the value to display as £2,200 but it rounds the number to appear as 2.2k.

I can't see any way of changing it. Has anybody looked at this before?

[jmaher]

I found the following solution to prevent the rounding of numbers when using a card graphic. 
1 - Click on the card graphic
2 - Click on Format Your Visual
3 - Click on the Visual Tab
4 - Scroll down to the Callout value and click the drop down arrow to expand the options

5 - Set the decimal places to whatever you need them to be. 

[GabrielL]

I have the same issue, I wish they would give us more control.

For example, I'm forced to format KPIs in this manner once they cross the 1K threshold:

It is unnecessarily confusing.

[PowerBIWhat]

Hi,

This isn't a PBI desktop feature. It is the Metrics tab which has just been released on the service. In desktop and on the PBI app the values are 2,200 but for some reason in the Metrics tab on the score card it shows as 2.2k. Odd.

[ama209]

Hi, thanks for clarifying. I've tested it out as well and I could not find a way to reflect commas. It appears the default setting is in thousands. However, you can add a currency symbol by clicking on the three dots in the bottom-right of the visual and selecting 'Edit Metric'

Afterwards, click into the area of the specific value (in your case where 2200 would be). There should be a pop-up window on top > change the data format to 'currency' and set the decimal places to 2 as shown below

Even though this doesn't completly solve the problem, I hope it helps!

[PowerBIWhat]

Yep, that is the method i've gone for. Not perfect and don't think I could release to the business with that format.

Thanks for the help. Hopefully Microsoft can make the small change.

[ama209]

Hi PowerBIWhat, have you tried the following in PowerBI Desktop?

For adding the £ symbol:

-- Go to 'Data' view > Select the column that the metric is pulling from >Under the 'Column Tools' tab (in the ribbon up top), click on the arrow beside the currency symbol (it might look like a '$' based on your region) > Select '£ English (United Kingdom)'. This will convert the values in the column to the £ currency. THEN make sure to select the ',' icon which is in the 'formatting' section of the ribbon. This ensures that commas will be included when values reach 1,000 or 1,000,000 and so on.

For displaying £2,200 on the card

-- Go back to the 'Report' view > Select the scorecard visual > In the 'Visualizations' pane (typically on the right of your screen) > Click on the 'Format your visual' icon (looks like a column chart with a paint brush on it) > Select 'callout value'  > Change 'Display units' to 'None'.

Let me know how it goes and please like if you found this helpeful.