Forum Discussion
DAX Conditional Number formatting
My understanding is that if you want conditional formatting, you are stuck with Strings. If you need to make numeric operations, keep the source information different to the display information. I.e. you have a Calc measure that does all of the work, and can be use by other measures further down your chain. Then have a Display measure that is simply the conditional format of your Calc.
Hi Anonymous,
I have tried to do that, but when that is in a chart visual the chart does not know how to display it as it changes the data type into string.
I also tried to wrap the Format in VALUE but Value was not able to convert the String into a number.
Any ideas?
My understanding is that if you want conditional formatting, you are stuck with Strings. If you need to make numeric operations, keep the source information different to the display information. I.e. you have a Calc measure that does all of the work, and can be use by other measures further down your chain. Then have a Display measure that is simply the conditional format of your Calc.