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)
RE: Number formatting
Most of the world knows better than to use the mm/dd/YYYY format, since it is ambiguous compared to dd/mm/YYYY. But the International Organization for Standardization (ISO) also understand the reversed ambiguity and has chosen an even better format as international standard, namely YYYY-mm-dd (or YYYYmmdd). Please follow international standard.
RE: Number formatting
Text formating (Format function) on Quick measures list
RE: Number formatting
For building dashboards for the corporate finance and accounting community, it would be very helpful to include number formatting that allows the user to (1) replace zeros with dashes, (2) show negative numbers in a matrix table with brackets or parentheses, and (3) allow the user to toggle on conditional formatting to highlight negative values in red.
RE: Number formatting
Having this feature would be really awesome! Please add!
RE: Number formatting
Allow the user to change the default format for different data types and create custom formats (similar to custom formats in Excel).
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.