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
Ideally the number & date formatting options should be as in Tableau. There can be a default format for any field, not restricted to the selections in the dropdown. At the same time we also need to override the formatting in the specific visuals also
RE: Number formatting
I would agree with this post. Not being able to use power BI to build and share metrics in a readable format is holding us back from using this tool within our Enterprise 100 company. If the numbers are hard to read (missing commas, scaling factory is not able to be adjusted etc.) there's no way I can use this tool to build effective dashboards to show to my leadership. We'll simply have to use something else. If you match what you have in Excel then we'd be happy.
RE: Number formatting
Agreed, I would be very interested in this as well.
RE: Number formatting
I wish I could format the number in the visualizations (for example to have the thousand separator and so)
RE: Number formatting
Agree with others custom date formats would be very useful. At the very least Mmm-YY (Oct-17) should be added to the available list. This looks best on charts and is not ambiguous for international use.
RE: Number formatting
This feature of allowing to customize date formats is really necessary.
You can define columns with a specified date format but in some cases such
as when using SUMMARIZE the FORMAT cannot be applied to define the date
presentation
RE: Number formatting
PLEASE FIX THIS! If I cant get the visual formatted correctly, it just doesn't matter how good the data model is (how many connectors, how many insights, etc).
Please fix this, and other basic things (format negative numbers as red) so we can get adoption for this tool.
RE: Number formatting
In the matrix and table visuals, there already exists a "Column Formatting" drop down menu that lets you manage column specific settings. It would be nice to have the ability to set number formatting at the column level.
I have a lot of $ measures that would be nice to show rolled up to higher denominations in some tables. Eg, $10,000 to $10T or $1,000,000 to $1M.
RE: Number formatting
Strange to see so many posts on this 'improvement' needed yet I don't think anything has been done. Please help!
RE: Number formatting
The ability to format numeric values and have them in charts would be extremely useful. Whilst using the FORMAT () function works very nicely for tables and matrices the fact that these measures cannot be used in charts is a real limitation.