331
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?
STATUS DETAILS
Needs Votes

Comments

C

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?

C

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.

C

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.

C

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.

C

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.

C

Really needed when working with the switch statement and dynamic measures. Please work on this

C

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.

C

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/

C

Please add this feature. We need it ASAP. Thanks!

C

This would be a very helpful feature.