Skip to main content
Microsoft Idea

Power BI

Needs Votes

Number formatting

Vote (464) 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 (69)
's profile image Profile Picture

Power BI User on 16 Aug 2020 04:08:55

RE: Number formatting

(This is for when displaying the figures in a table in a report/dashboard) - OP

's profile image Profile Picture

Carlos Eduardo de Laia Santos on 16 Aug 2020 04:08:51

RE: Number formatting

The Tool is very good but I think the custom dataform is missing. For this, the system limits the use of standard formats.

's profile image Profile Picture

Carlos Eduardo de Laia Santos on 16 Aug 2020 04:08:51

RE: Number formatting

The Tool is very good but I think the custom dataform is missing. For this, the system limits the use of standard formats.

's profile image Profile Picture

Robert Jensen on 16 Aug 2020 04:08:37

RE: Number formatting

Parentheses should be a standard numerical formatting option and red being an additional (non-mutually-exclusive) option. Parentheses are only currently available under US Currency, but should be made available to all numerical options (e.g. Decimal, %'s &c.)

's profile image Profile Picture

Mirza Fawad on 16 Aug 2020 04:08:25

RE: Number formatting

I prefer to see negative numbers expressed in brackets and red

's profile image Profile Picture

Federico 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

Federico 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

John on 16 Aug 2020 04:08:03

RE: Number formatting

Please add.

's profile image Profile Picture

Roshan Taghavi 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

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