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)
Still relevant. I could use this functionality for a current project!
RE: Option to FORMAT () values as numbers (not strings)
Either allow a specific number type to be included in the FORMAT() function or allow formats to be applied with an expression from a data driven field in the model within the measure formatting window. The format measure window currently only allows a static input, but ultimately setting a format here still allows measures to be plotted to charts.
RE: Option to FORMAT () values as numbers (not strings)
Why allow a user to create a measure and format as currency/percentage etc and give the output as text so you can't plot on a chart, which is the whole purpose of Power BI?Please can this be done?
RE: Option to FORMAT () values as numbers (not strings)
Please implement this - as mentioned it's a standard function in other tools I've used, and would let us cut down on whole series of duplicate measures.We can manually change number formats by clicking buttons in PBI desktop, so we should be able to automate this via DAX without having to convert to text (meaning the measure can't serve as a basis for other numerical measures). Currently the only workaround for me involves at least doubling the number of measures used; not practical in a large model.
RE: Option to FORMAT () values as numbers (not strings)
The big issue with the format function as it stands is that the output is text. When exporting to excel it complains that our numbers are now text. Need to be able to dynamically change the actual format of the number in Power BI so that the format of the number is passed and that the number remains as a number. We are working on a conversion from Cognos to Power BI and this is something that Cognos does by default.
RE: Option to FORMAT () values as numbers (not strings)
How is this not a thing yet? It would be extremely helpful. I want to dynamically change a graph between percent and currency depending on whether the user picks Gross Margin or Gross Profit. Right now the only option is to display as a decimal number. Not nearly as clean looking.
RE: Option to FORMAT () values as numbers (not strings)
We would like a newly created measure's data type to dynamically switch between PERCENTAGE and WHOLE NUMBER. Currently, the FORMAT() function converts to a string which is unusable. Thank you.
RE: Option to FORMAT () values as numbers (not strings)
Really needed when working with the switch statement and dynamic measures. Please work on this
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/