Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Number formatting

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.
Status: Needs Votes
Comments
stotsky_mv
New Member
How can a russian user read this: 26bnP. What does it mean? we need to control it something like 26 млрд
stotsky_mv
New Member
How can a russian user read this: 26bnP. What does it mean? we need to control it something like 26 млрд
yoshihiro
New Member
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.
yoshihiro
New Member
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.
yoshihiro
New Member
I want to use 4 digits, and MAN, OKU for money number display unit. 10000 YEN = 1 MAN YEN 100000000 YEN = 1 OKU YEN.
Alex91
New Member
Yes please!
matthew_ley
New Member
The ability to enter and use Custom Date Formats within BI (E.g. mmm-yy) rather than having to use the pre-set formats.
mkrohn
New Member
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...
kevhav1
New Member
I agree. Specifically, in the "Modeling" screen. For a model with a date column, you can pick from a list of formats. I'd like to be able to enter a custom format. Or, if it's easy to add another format to the list of formats, I would really like to see "ddd, yyyy-MM-dd" ... or, for example, "Thu, 2016-08-04" Thanks!
kien_low3
New Member
Totally agree that this is needed. Can't believe that dd-mm-yyyy is not included in the pre-set formats...