Forum Discussion

linphan's avatar
linphan
Frequent Visitor
8 years ago

Display Infinity & NaN value as a text

Hello, Im newbie in power Bi community. I have a question to display Infinity & NaN as 2 different values. Im using matrix to dislay gap (%) between actual volume & forecast volume. And I need to do...
linphan's avatar
linphan
Frequent Visitor
8 years ago

Hi Jimmy,

 

Switch function does not work. I got the error as below

"Function SWITCH does not support comparing values of type Number with value of type Text. Condider using VALUE or FORMAT to convert one of the values"

linphan's avatar
linphan
Frequent Visitor
8 years ago

 

This is the screenshot