Forum Discussion
Key influensers visual
I get an error when trying to create a key influencers visual:
Can't display the visual
<pi>Query (3, 116) DAX comparison operations do not support comparing values of type Number with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.</pi>
I'm using Average price which is decimal numbers as "Analyze" and Category (text - A, B, C...) as "Explain by". (Still error if I convert Average prise to whole number)
Shouldn't I be able to explain a measure with different dimensions (not measures)?
Hi Dall ,
From the error message, you may change the related part of formula like VALUE([Analyze]), or the field compared with [Explain by] would have to be text type .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Dall ,
From the error message, you may change the related part of formula like VALUE([Analyze]), or the field compared with [Explain by] would have to be text type .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.