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

Kien on 16 Aug 2020 03:54:00

RE: Number formatting

Totally agree that this is needed. Can't believe that dd-mm-yyyy is not included in the pre-set formats...

's profile image Profile Picture

Mathias Mathias on 16 Aug 2020 03:53:55

RE: Number formatting

Would be important to have this. E. g. to report on monthly data in a table or matrix. The available Month/Year format heavily inflates the column width, so not usable... Something like "MM/yy" or "MMM/yy" would be needed...

's profile image Profile Picture

Welldrake on 16 Aug 2020 03:53:09

RE: Number formatting

Yes please!

's profile image Profile Picture

Matt Ley on 16 Aug 2020 03:53:08

RE: Number formatting

The ability to enter and use Custom Date Formats within BI
(E.g. mmm-yy) rather than having to use the pre-set formats.

's profile image Profile Picture

Kawabata Yoshihiro on 16 Aug 2020 03:52:06

RE: Number formatting

I want to use 4 digits, and MAN, OKU for money number display unit.

10000 YEN = 1 MAN YEN
100000000 YEN = 1 OKU YEN.

's profile image Profile Picture

Kawabata Yoshihiro on 16 Aug 2020 03:52:06

RE: Number formatting

I want to use 3 digits, and K, M for IT related number display unit.

10000 Bytes = 10 K Bytes.
100000000 Bytes = 100 M Bytes.

's profile image Profile Picture

Kawabata Yoshihiro on 16 Aug 2020 03:52:05

RE: Number formatting

I want to use special Display Unit of the number cultures.

In Japan,
Money number's display unit is 4 digits unit, and MAN, OKU, TYO.
and Storage's display unit is equal to US, 3 digits and K,M,G.

's profile image Profile Picture

mikhail stotsky on 16 Aug 2020 03:51:40

RE: Number formatting

How can a russian user read this: 26bnP.
What does it mean?

we need to control it
something like 26 млрд

's profile image Profile Picture

mikhail stotsky on 16 Aug 2020 03:48:31

RE: Number formatting

How can a russian user read this: 26bnP.
What does it mean?

we need to control it
something like 26 млрд