Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have the following table. In the income column, that has several 'NULL' values.
My first thought was to replace it with a blank, that I am unable to do. I tried replacing 'NULL' with 'NOT AVAILABLE', that too was not possible as the column is set to 'whole number' type.
Can you please suggest what's the best way to deal with this scenario?
Solved! Go to Solution.
@jp25 ,
NULL values will be reflected as blanks on the report, no need to make any change.
If you want to do, you make it to zero. Replacing with 'NULL' or 'NA' or any string value then you have to make your column to TEXT type.
Regards,
Manikumar
Proud to be a Super User!
@jp25 ,
NULL values will be reflected as blanks on the report, no need to make any change.
If you want to do, you make it to zero. Replacing with 'NULL' or 'NA' or any string value then you have to make your column to TEXT type.
Regards,
Manikumar
Proud to be a Super User!
@manikumar34 . Thank you. I was a bit confused. I think I will change it to a zero. So I don't get an error in the case, I use this column as a measure, so, for example, average income etc..
Is there a reason you need to chande the null value to blank? Null values are blank by default once loaded
Proud to be a Super User!
Paul on Linkedin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |