Forum Discussion
Getting rid of NeuN value
Anonymous Testing different things you suggest, leads me to the original csv. I added a new row and saved it again. Now, when loading into Power Bi, there is no problem at all to get rid off the NaN values. I can use "replace values" and It recognizes them perfectly. I presume there must be an error in the way csv file is built from original source. Thanks for your help!
Hi Anonymous
I think this issue is consistent for all columns at same row.
Hence even if you apply filter at particular column this will remove all associated rows.
Query editor-> and unselected only neun values from any column.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
In the query editor you can select all column then press right mouse button and use replace values. Search for NeuN and replace with 0 or a space.
Anonymous I have already did that but it does nothing. NaN values are still there.
What happens if you do not pull it in as a decimal but as a text? what does it show then?
Could you maybe share anonimized sample data for me to try somethings myself?Anonymous Testing different things you suggest, leads me to the original csv. I added a new row and saved it again. Now, when loading into Power Bi, there is no problem at all to get rid off the NaN values. I can use "replace values" and It recognizes them perfectly. I presume there must be an error in the way csv file is built from original source. Thanks for your help!