Forum Discussion
Dynamically format a measure as $ or %
Hi there, Is there a way we can dynamically format how a measure X is displayed, either in $0.00 or %, depending on the values in another field? I have a separate field called 'Data Type' which I...
It's true. Once you use Format() function, the data type will be converted to text, it will throw error if you change it to numeric type.
It's not possible to give a dynamic format on a measure but still keep numeric data type.
Regards,
Hi! I'd very much like this to be suggested as a fix. We often want to be able to show dynamically formatted measures in graphs.
I've created an idea requesting that this be implemented. Please help vote it up! https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35921176-option-to-format-values-as-numbers-not-strings
