Forum Discussion
Replace Values Null to Blank or Blank to Null
Hello All,
In few of my columns i have null values and when i use that column in a slicer option it gives me two different options.
If i check the Blank option it just shows the Nulls, it soesnt show Blank in that columns. And if i check the below nulls it shows the sme Nulls. So i would like to convert to have either null or Blank. I have tried the Replace value in Transform data for that column but it doesnt change anything.
Can anyone please help me with this.
In the above you are only handling the values where there is a value, "" or " ". You need to convert them all to null or convert all the null's to "".
At the moment you have two different values:
1. null
2. ""
6 Replies
tzvetkov_b87Helper I
Hi Anonymous ,
I can think of two reasons that might be happening.
The (Blank) option will be showing up when the Status values are empty (there is no data entered there).
The option below (Blank) could be where you have an empty String in your Status.
For example if the Status is just an empty space " " or mabye " " would show up as that.
Where are you getting this data from? Might be worth going to the source of the data, and cleaning it up there if possible?
Let me know if this helps.
- tzvetkov_b87
In the above you are only handling the values where there is a value, "" or " ". You need to convert them all to null or convert all the null's to "".
At the moment you have two different values:
1. null
2. ""
Anuja_Chaudhari- Load your data into Power Query.
- Select the column where you want to handle null and blank values.
- Go to the "Transform" tab.
- Click on "Replace Values" in the "Any Column" group.
- In the "Replace Values" dialog box, enter null as the value to find.
- Replace it with an empty string "" or any other value that represents blank in your context.
- Click "OK" to apply the changes.
- Load the data into Power BI.
