Clara on 06 Nov 2018 20:57:37
The FORMAT () function should be extremely flexible for conditionally formatting measures based on slicers and so on. But right now not even chart visuals agree with it. Please fix it? Pretty please?
- Comments (33)
RE: Option to FORMAT () values as numbers (not strings)
Please add this feature. We need it ASAP. Thanks!
RE: Option to FORMAT () values as numbers (not strings)
This would be a very helpful feature.
RE: Option to FORMAT () values as numbers (not strings)
Have created visuals that allow user to dynamically choose measures to display but need to way to dynamically format the numbers, since some are percentage, decimal, integers, etc.
RE: Option to FORMAT () values as numbers (not strings)
Please add it, we need it asap
RE: Option to FORMAT () values as numbers (not strings)
I need this to plot a measure trend using the switch functionality to switch between unit types (%, currency, whole number etc). It seems to work ok for tooltips but not plotting on a chart
RE: Option to FORMAT () values as numbers (not strings)
Would really love this as a feature. Without this, the use of dynamic metrics is limited.
RE: Option to FORMAT () values as numbers (not strings)
By when we can expect this functionality?
RE: Option to FORMAT () values as numbers (not strings)
Plase add this function!
RE: Option to FORMAT () values as numbers (not strings)
Can't believe this isn't supported already! I want to use a dynamic measure that switches between Sales and Units (using FORMAT to convert between "$#,##0" and "#,##0.00"). The measure works beautifully, but I lose the ability to sort the table because it is now recognized as text!
Such a basic feature that is desperately needed. Please fix!
RE: Option to FORMAT () values as numbers (not strings)
Yes, in addition, in Excel, negative number like -12345 can be formatted as a bracketed number (not text) as " (12,345). After formatting negative as bracketed number, it right align with positive numbers as Excel gives a space on far right of positive number to match the closing bracket of negative number. Thanks PBI team for great work but pls PBI team help to achieve this same formatting capability as this is a basic need of any table/matrix visual otherwise it is useless.