values in the graphs are not displayed

[Anonymous]

I have some graphics that instead of presenting the value NaN is presenting, and position the mouse pointer on the graph the value is displayed as the image down, why this happens? and how to solve?

[Anonymous]

Hi @Anonymous,

Based on my test, NaN value can be returned in the following scenarios, please check them in your column.

0/0 = NaN
(2/0)/(3/0) = NaN
0/BLANK() = NaN

Also use ISERROR() function to check if your value is NaN, if the function returns True, it means that your value has errors.

Thanks,
Lydia Zhang

[Anonymous]

@Anonymous @ankitpatira

thak you for your help,

As you can see in the picture, I am using the expression the ISBLANK () function, and formatted the indicator to be percentage, how could I use the ISERROR () function in this case?

Note: this image has no filter applied.

[Anonymous]

Hi @Anonymous,

You can create another measure as follows and use ISERROR() function to check if your value has errors. Drag the CheckMeasure to a table visual and check if it returns "True".

CheckMeasure = ISERROR(YourMeasure)

Thanks,
Lydia Zhang

[Anonymous]

ok did a test and showed true, but I see the error in my expression

ISERROR((sum(Fatos[Vl_Receita])-sum(Fatos[Vl_Estorno])*100)/sum(Fatos[Vl_ReceitaPrevista]))

[Anonymous]

Hi @Anonymous,

Please check if the following expression returns value like"0/0", "0/BLANK()", and make sure the measure is not defined as Text data type. 

(sum(Fatos[Vl_Receita])-sum(Fatos[Vl_Estorno])*100)/sum(Fatos[Vl_ReceitaPrevista])

Thanks,
Lydia Zhang

[ankitpatira]

@Anonymous NaN means not a number. Are you anywhere formatting that column to a Text field type. If you format that field to percentage or decimal number then that should solve the problem.