Forum Discussion
DAX And Conditional Format
Hi Anonymous ,
// Calculation error in measure 'CallData'[Conditional Format]: Cannot convert value "::" of type Text to Type number.
Please use 'CallData'[AvgAnsTime] instead of 'CallData'[Avg Ans Time (Mins)].
'CallData'[AvgAnsTime] return a number value but 'CallData'[Avg Ans Time (Mins)] returns a text value, which can't be used in Maths functions.
Try this:
color = IF ( 'CallData'[AvgAnsTime] > ( 15 * 60 ), "#ff0000")Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Unfortunately not, I did the formula using the columns it says it can not display the visual. (Calculation error in measure 'CallData'[Conditional Format]: Cannot convert value "::" of type Text to Type number.
I also tried something else, but instead of conditionally formatting it, it instead just put "#ff0000" as the record in the table instead of actually coloring it
Hi Anonymous ,
// Calculation error in measure 'CallData'[Conditional Format]: Cannot convert value "::" of type Text to Type number.
Please use 'CallData'[AvgAnsTime] instead of 'CallData'[Avg Ans Time (Mins)].
'CallData'[AvgAnsTime] return a number value but 'CallData'[Avg Ans Time (Mins)] returns a text value, which can't be used in Maths functions.
Try this:
color =
IF ( 'CallData'[AvgAnsTime] > ( 15 * 60 ), "#ff0000")
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.