Skip to main content

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

cc4767aa d8a5-4652-97b5-95b6db99d26d 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

0b704a45 224a-4e9a-b602-1fe80436164c 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

7a74a329 783f-46b5-9393-ea21115a6ac6 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

38cc135b 952b-4d91-a0e2-81772b35eea7 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

063d9c11 9bd0-45f4-a2c6-66372408cd19 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

b2bdcad6 5de6-4f51-8eef-ab6a49256359 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

3011e3a7 630a-4ab3-80c0-daa184676095 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

b2da1462 b40a-439f-978f-a3734e2a8634 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

b1eb09b3 0d0e-4027-a73b-efdcd1f22704 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

a371fd34 85dc-4f4a-b087-2c6584bb289a 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