Option to FORMAT() values as numbers (not strings)
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?
I support it.
Hi, I definitely support this feature - I expected this to be basic functionality and I was quite disappointed to find out it does not work. Please, fix it. Thanks
Scott Ho commented
I am currently developing a Sales report for a multi-national company who has shops from around the world. The Headquarters in Europe wants to see Sales reports in EUR as that's what makes sense to them. However, a big share of the retail revenue is coming from Australia in transaction currency in AUD. Headquarters also fixes the exchange rates that we need to use for reporting purposes. The daily currency market movement is irrelevant as financially reporting is done only monthly. I didn't want to create two different measures like Actual MTD and Actual MTD (EUR). I preferred to use only one measure called Actual MTD.
When we deal with currencies, we always talk currency value and symbol to make sense. So naturally I had to add two parameters and control the calculation and DISPLAY of the Actual MTD:
ShowEuroCurrencyValue = TRUE
ShowEuroCurrencySymbol = TRUE
But the second parameter would expose this Power BI limitation in formatting (converting numeric to text). The solution I came up is instead of changing the format on the measure itself, I had to add a Card on the page at the top to show viewers either AUD or EUR.
Being able to dynamically set the datatype of a measure is key for formatting a column with multi data types. For example, I have a field filled with answers to survey questions. These answers can be anything from dates, text, currency, number, or percentage. I want these values to be displayed in a matrix visual as one column with the appropriate formatting (e.g. $, %, etc)
I need this so much as well..
Really need this and this is supposed to be a basic functionality!
It is really important when you want to make a dynamic measure! You be able to choose format for them!!!
Please fix the format function to work with the switch statement
Andrew Walker commented
This is soooo easy to do in Qlikview!