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

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

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