Skip to main content

Power BI

Needs Votes

Number formatting

Vote (376) Share
's profile image

on 09 Feb 2017 18:19:25

The number formatting should be in accordance with excel. The options available in excel for number formatting is quite brilliant.
I hope Power BI can somehow integrate custom number formatting in the desktop version.

Thank you.

Comments (64)
's profile image Profile Picture

840b7b82 6916-4da7-bfdf-7053f17b5fe0 on 16 Aug 2020 04:08:05

RE: Number formatting

Power Bi should be available to create a custom unit format like (w) in electricity power!

's profile image Profile Picture

840b7b82 6916-4da7-bfdf-7053f17b5fe0 on 16 Aug 2020 04:08:05

RE: Number formatting

Power Bi should be available to create a custom unit format like (w) in electricity power!

's profile image Profile Picture

8e9d5c6e 8b92-4596-bf58-65b435d86084 on 16 Aug 2020 04:08:03

RE: Number formatting

Please add.

's profile image Profile Picture

e47737b0 65b3-4143-9ce6-eb9fa0fa52d2 on 16 Aug 2020 04:07:55

RE: Number formatting

It seems that currently there is no option that would simply add a bracket to negative numbers for formatting purposes. Please add this as I believe a lot of people need this simple formatting feature. Thanks.

's profile image Profile Picture

e4044509 32bf-4877-873c-e2cb21099378 on 16 Aug 2020 04:06:10

RE: Number formatting

It looks like the latest version of Report Server included the ability for "modeling" an actual number rather than just a measure, so now I can add a thousands separator everywehere I need to without having a duplicate field just for that.

This has definitely moved forward a long way, although not quite as far as asked for.

's profile image Profile Picture

58a7802a 1032-4dcd-8ea7-39b6b4cbd84b on 16 Aug 2020 04:06:08

RE: Number formatting

I prefer to see negative numbers expressed in brackets and red. KO

's profile image Profile Picture

92893e15 34db-4048-8226-3adce15f6190 on 16 Aug 2020 04:04:51

RE: Number formatting

Need to include India's Number Format.

Currently we have US number format in the App due to which it's creating confusion and difficulties in visualization.
For Example in Power BI Desktop App it is 150,443,572 which is a US format but in India it's 15,04,43,572.

So, it will be better for visualization if we also include Indian Number Format.

's profile image Profile Picture

8a5f2d5a 6391-49f5-86b0-f7e6eed0f1bc on 16 Aug 2020 04:04:17

RE: Number formatting

Agreed! What good is showing us all those special codes that go into formatting the different date options if we can't then USE them to create our own!

Specifically, I'm looking for yyyy MMM, or "2018 Mar"

's profile image Profile Picture

b654d80f 550f-4223-8538-df9b563e0c61 on 16 Aug 2020 04:03:40

RE: Number formatting

To have the option of adding parenthesis on a number when it is negative - conditional formatting.

's profile image Profile Picture

7bc6f317 09da-46a1-8329-2103ea710e45 on 16 Aug 2020 04:02:57

RE: Number formatting

In most Common Wealth countries the date format is dd/mm/yy. The slicer is confusing to my customers in India as is shows the date in US format.