Number formatting

[arpitkumar2310]

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.

[fpena1]

Power Bi should be available to create a custom unit format like (w) in electricity power!

[lazarus_viasti1]

All people in Finance or FP&A would request this! Much needed

[ho-acc_yossil]

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.

[bethany_ferrell]

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.

[patrick_marchek]

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.

[trang_doan]

Having this feature would be really awesome! Please add!

[christopher_sma]

Allow the user to change the default format for different data types and create custom formats (similar to custom formats in Excel).

[arvid_baarnhiel]

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.

[romuald_ebala]

Text formating (Format function) on Quick measures list

[olivier10]

Related idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15231165-conditional-formatted-measures-using-switch