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
Completely agree, the focus seems to be solely on US date formats.
RE: Number formatting
Very much needed feature. Need formats such as MMM YYYY and MMM YY.
RE: Number formatting
Please add MMM-YY and MMM-YYYY to the presets list.
RE: Number formatting
Surely there is a need for greater / easier formatting of numbers. For example, I have a simple sales table showing YTD sales v target which run in to millions and I want to show in thousands as there's a lot of other big numbers in the table and I want to do away with some clutter. The fact I have to add in new columns and write DAX to change each column is far too time consuming. We should be able to do this via the modelling and format options at the click on the button. Such a shame because my first reports have had a warm welcome from the Management team but I cant fully publish until I get this layout corrected.
RE: Number formatting
I'm an accountant and in all of our Excel based reports we prefer to have negative numbers in brackets and in red. This is a fairly common practice.
The flexibility of Excel number formatting is great. We need this in Power BI
RE: Number formatting
Dates are so frustrating for anyone outside of the Americas. Need formats equivalent to Excel
RE: Number formatting
It is normally in accounting reports to format revenue for readability
eg.
$123,456,789.12
as USD millions 123
we can already format the data labels on charts nicely but the functionality does not work for pivot tables.
This is annoying.
RE: Number formatting
We cannot format a measure only based on lowest and highest value
RE: Number formatting
I specifically need MMM-YY
RE: Number formatting
Confirmed gap: https://community.powerbi.com/t5/Desktop/Number-Format/m-p/324101#M144482.
Any update from MS on this?