Skip to main content

Power BI

Needs Votes

Number formatting

Vote (465) Share
's profile image

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)
's profile image Profile Picture

Arvid Bäärnhielm on 16 Aug 2020 04:11:12

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.

's profile image Profile Picture

Romuald EBALA on 16 Aug 2020 04:11:05

RE: Number formatting

Text formating (Format function) on Quick measures list

's profile image Profile Picture

Patrick on 16 Aug 2020 04:10:29

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.

's profile image Profile Picture

Power BI User on 16 Aug 2020 04:10:28

RE: Number formatting

Having this feature would be really awesome! Please add!

's profile image Profile Picture

Chris Small on 16 Aug 2020 04:10:16

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

's profile image Profile Picture

Beth on 16 Aug 2020 04:09:35

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.

's profile image Profile Picture

yossi on 16 Aug 2020 04:09:05

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.

's profile image Profile Picture

Laz on 16 Aug 2020 04:09:01

RE: Number formatting

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

's profile image Profile Picture

Power BI User on 16 Aug 2020 04:08:56

RE: Number formatting

This is desperately needed. It's the biggest barrier to creating clear reporting.

's profile image Profile Picture

Power BI User on 16 Aug 2020 04:08:55

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.