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

48fb5028 a476-4f19-ba91-218b92cdfa55 on 05 Jul 2020 23:44:30

RE: Customize the formatting of numbers

Hi,

The numbers within the table and matrix are displayed in Lakhs 10,00,000, than in Millions 1,000,000. The Power Query has been updated to reflect the numbers in 1,000,000s.

It doesn't even work after changing the Report --> Modelling view

Power BI Ideas Admin's profile image Profile Picture

725db739 3871-42a2-92bc-94b63941ed76 on 05 Jul 2020 23:36:30

RE: Customize the formatting of numbers

Hi,

We need a new option in Power bi desktop we are working with financial Reports we need to show amount in CR's(CRORE)

Power BI Ideas Admin's profile image Profile Picture

d097ec7d 5543-44e4-9965-e7b36c551d37 on 05 Jul 2020 22:56:24

RE: Customize the formatting of numbers

I can format numbers in SSAS, but the formatting does not flow through to PowerBI. And I cannot find a way to format numbers in PowerBI. I'm trying to format a table, but it should be possible to format numbers anywhere they are displayed.

Power BI Ideas Admin's profile image Profile Picture

d097ec7d 5543-44e4-9965-e7b36c551d37 on 05 Jul 2020 22:56:23

RE: Customize the formatting of numbers

Correction: Number formatting in SSAS does flow through to PowerBI matrices (and I hope, elsewhere). I had neglected to format my measures.

Power BI Ideas Admin's profile image Profile Picture

d638cd75 547c-4f28-8fac-22d9d480dd57 on 05 Jul 2020 22:53:14

RE: Customize the formatting of numbers

I am importing existing data models in to PowerBI to take advantage of the enhanced reporting capabilities but there are a number of issues making this difficult. One issue is the lack of ability to customize numbers as per Excel. For example, I produce our company P&L rounding to the nearest thousand and showing negative numbers in brackets with a red font. Are there any plans to introduce this in the near future?

Power BI Ideas Admin's profile image Profile Picture

e18056d8 a20a-4d16-b49c-aec37d9aeb68 on 05 Jul 2020 22:48:50

RE: Customize the formatting of numbers

its flag has completed, but how to use it?
in a table, I want to format my Sales $ automatically like the gauge visual do it.

Power BI Ideas Admin's profile image Profile Picture

595c7c45 9fc2-4086-afec-50431f1eca1c on 05 Jul 2020 22:45:05

RE: Customize the formatting of numbers

Microsoft seems to be treating POWERBI like a developer's obsession rather than a businessman's tool. Missing basic things like number formatting is an example of it

Power BI Ideas Admin's profile image Profile Picture

4976df7e a045-4f85-9f53-9abd9b418ef9 on 05 Jul 2020 22:37:47

RE: Customize the formatting of numbers

We can create a measure and use nested If to add "Cr"/"Lac"/"Thousand" after the value and pull it un visuals.

thats seems to work for me.

Power BI Ideas Admin's profile image Profile Picture

f3d79303 e82e-4dda-95c8-cc7573d7a346 on 05 Jul 2020 22:36:18

RE: Customize the formatting of numbers

I find it utterly ludicrous that no functionality exists for formatting numbers. I run my business to the penny, not to the nearest .1 million.

Power BI Ideas Admin's profile image Profile Picture

c3cb1933 de2d-47f3-8aa0-d0a2821c5faf on 05 Jul 2020 22:36:00

RE: Customize the formatting of numbers

This seems to be on a visualisation by visualisation basis. I am using the custom Text Scroller visualisation and it does not include the "Data Label" option to be able to control this.