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 (35)
RE: Option to FORMAT () values as numbers (not strings)
Since Power BI is a visualization tool, therefore the format of the measure should be the same as function indicates.
Example, Measure = FORMAT( 12345.67, "Currency"), the format of the measure should be currency.
RE: Option to FORMAT () values as numbers (not strings)
Hi all!
In this article you can find some workaround to make your numbers formatted in dynamic way:
https://rollingaverage.com/set-up-measure-selection-with-dynamic-formatting-in-powerbi/
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!