Skip to main content
Microsoft Idea

Power BI

Completed

Customize the formatting of numbers

Vote (76) Share
Power BI Ideas Admin's profile image

Power BI Ideas Admin on 21 Oct 2014 06:22:27

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".

Comments (24)
Power BI Ideas Admin's profile image Profile Picture

Arvind Naik on 05 Jul 2020 22:34:21

RE: Customize the formatting of numbers

Where can I find the solution for this? I am not able to summarize my numbers with comma separator Example 1234567 could be represented as 1,234,567 etc. Especially for count and sum calculations. This is a major h

Power BI Ideas Admin's profile image Profile Picture

Vijay on 05 Jul 2020 22:32:09

RE: Customize the formatting of numbers

Hi, I am trying to remove decimals from single number cards....Can anybody help.

Power BI Ideas Admin's profile image Profile Picture

Magnus Viermyr on 05 Jul 2020 22:27:48

RE: Customize the formatting of numbers

Yes, this is a must have!

Power BI Ideas Admin's profile image Profile Picture

Arvind Vete on 05 Jul 2020 22:17:28

RE: Customize the formatting of numbers

Please give the facility of Indian number System also like (9999999.99]##\,##\,##\,##0.00;##\,##\,##0.00)

Power BI Ideas Admin's profile image Profile Picture

Vincent on 05 Jul 2020 22:15:00

RE: Customize the formatting of numbers

I also agree. This is a must-have feature.

Power BI Ideas Admin's profile image Profile Picture

Sandeep on 05 Jul 2020 22:10:45

RE: Customize the formatting of numbers

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

Power BI Ideas Admin's profile image Profile Picture

Sanjay Shah, Pune, India on 05 Jul 2020 22:05:18

RE: Customize the formatting of numbers

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..

Power BI Ideas Admin's profile image Profile Picture

kms on 05 Jul 2020 22:04:27

RE: Customize the formatting of numbers

Is this going to be implemented in the September update?

Power BI Ideas Admin's profile image Profile Picture

Christopher Woodward on 05 Jul 2020 22:04:12

RE: Customize the formatting of numbers

Hope we see this in the Sept update.

Power BI Ideas Admin's profile image Profile Picture

Gee434 on 05 Jul 2020 22:03:47

RE: Customize the formatting of numbers

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