Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

pbiideas1

Customize the formatting of numbers

Submitted by on ‎10-20-2014 11:22 PM
You should be able to control the formatting of numbers in tiles on the dashboard and in reports. For example a tile that shows "0.1M" might be better with a more precise number like "123,456".
Status: Completed
See more ideas labeled with:
25 Comments (25 New)
Comments
balsamoma
Microsoft Employee
Microsoft Employee
‎07-05-2020 02:56 PM
I agree. I need to be able to set the # of digits beyond the decimal point. In the edit experience, I see 105.20 and in the dashboard experience, I'm seeing either: 105 OR (when I do a min value) 105.9877777 (when I do an average) What I want in both places is 2 digits after the decimal point. I'm not seeing the exact number I want.
denglishbi1
New Member
‎07-05-2020 02:59 PM
definitely want to be able to control the formatting of numeric values. number of decimal places and commas, pretty basic, but not able to do in just the query. hopefully when the model is exposed this month...
anuj_soni
New Member
‎07-05-2020 03:02 PM
Hi Guys... One more thing I noticed in power BI designer that it hangs after sometime and blocks other applications also. Can you please let us know if you have faced any issues like this?
DaveBreyley
Advocate I
Advocate I
‎07-05-2020 03:03 PM
One use case is on a bar chart, we summarizing sales. The sales range from $14,000 to $800,000 but the axis shows as millions we would rather show the axis as hundred thousands
Gee434
New Member
‎07-05-2020 03:03 PM
We are using Gauge to track sales against budget. Our sales folks would like to see $349.23K instead of 0.35M. Number format flexibility will be very helpful
xxcorpxx
Advocate V
Advocate V
‎07-05-2020 03:04 PM
Hope we see this in the Sept update.
kms1
New Member
‎07-05-2020 03:04 PM
Is this going to be implemented in the September update?
fbcideas_migusr
New Member
‎07-05-2020 03:05 PM
It must not be hardcoded. I should be be able to see what level of accuracy as well as where the commas need to be. It must address the Indian numbering system of crores, lakhs etc.. rather than million, billion etc..
v-sanjos
New Member
‎07-05-2020 03:10 PM
HI Is anyone has idea on how to set number format in "KPI Indicator with Status "custom tool as it's showing numbers to all decimal places like 1.0158675M I want to make it to 1.01M even in Backend model number precision has been taken care but only for this particular viz it's not working.Can anyone please help
vincentvanaspe1
New Member
‎07-05-2020 03:15 PM
I also agree. This is a must-have feature.