chart data contains nan values. Could not convert nan to numeric. You can check whether they exist in your measures.
chart data contains nan values One visualization i have is a clustered column chart. Quarter, i get the (i) appear that contains the. A user reported an error on a chart with data that contains nan values:
0 / Blank () =.
When on the year level all it good, however as soon as i drop to the next level i.e. Hi, i have come across a number of sources saying that excel ignores #n/a while plotting a line chart, however, it does not do so for me. Could not convert nan to numeric.
You Can Check Whether They Exist In Your Measures.
Quarter, i get the (i) appear that contains the. The values are the count of each product purchased. For troubleshooting, you can create another measure iserror() function to check which value is nan value.
Is There A Way To Simply Ignore The.
Instead, it joins the points. Nan (not a number) will be shown in following conditions. I think it might be because the second problematic column contains nan values.
One Visualization I Have Is A Clustered Column Chart.
A user reported an error on a chart with data that contains nan values: