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)
RE: Number formatting
I need to be able to display the dates in a custom format WITHOUT them no longer being a date. That way sorting can still happen by date. I need to be able to do things like ddMMMyyyy or dd-MMM-yyyy. Two formats you do not have. Please just give us the freedom to format the date however we want to without restricting us to the list of very few that you have.
RE: Number formatting
enable formatting negative numbers with brackets or even changing color and still remains as number (not text and not currency).
exactly like we have in Excel.
RE: Number formatting
All people in Finance or FP&A would request this! Much needed
RE: Number formatting
This is desperately needed. It's the biggest barrier to creating clear reporting.
RE: Number formatting
(e.g. 12.6% to display as +12.6%)
Currently possible in excel. With power bi the only workaround is to format the field as text which losses the numeric value of the figure if also using in charts.
RE: Number formatting
(This is for when displaying the figures in a table in a report/dashboard) - OP
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.
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.
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.)
RE: Number formatting
I prefer to see negative numbers expressed in brackets and red