Chart visual contains not a number (NaN) values

[runski]

Hi.

I have an error message in one of my charts. It says the chart contains NaN values and it will not interact properly. I can't click on a bar and filter other visuals on the same page for instance. Any idea on how I can resolve this or identify the data being recognized as invalid?

Format of dimension on axis is text, format of measure is decimal.

Thanks.

[MattAllington]

try duplicating the report, then change the visualisation to a matrix.  You could also put the visualisation into full screen, then click on "show Data".  This will show you the underlying data.  Chances are you have a divide by zero error I guess.  Are you using the DIVIDE funciton instead of /

[runski]

Hi, Matt.

Thanks for the quick response and the great suggestions on how to view the underlying data.

I changed into a matrix, and can't see nothing but "normal" numbers in the grid. The measure is just a SUM(Table[column]) calculation. So the divide by zero error can't be in there.

[MattAllington]

Mmmmm, sum(table[column]). So what is in the column?  Can you check the column for maybe blanks?

[runski]

So, in the column there is numbers, from 0 to 1250. I can't see any blanks or null values.

[v-sihou-msft]

@runski

NaN (not a number) will be shown in following conditions. You can check whether they exist in your measures.

0 / BLANK () = NaN

0 / 0 = NaN

Infinity / Infinity = NaN (e.g. (10 / 0) / (7 / 0))

For troubleshooting, you can create another measure ISERROR() function to check which value is NaN value. For example, if ISERROR(SUM(Table[column])) returns "True", it means SUM(Table[column]) returns an error(e.g. NaN value).

If you still can’t find the issue, please provide share sample data or .pbix if possible.

Regards,