Replace Values Null to Blank or Blank to Null

[Sravya_Rajarapu]

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. 

[Anuja_Chaudhari]

1. Load your data into Power Query.
2. Select the column where you want to handle null and blank values.
3. Go to the "Transform" tab.
4. Click on "Replace Values" in the "Any Column" group.
5. In the "Replace Values" dialog box, enter null as the value to find.
6. Replace it with an empty string "" or any other value that represents blank in your context.
7. Click "OK" to apply the changes.
8. Load the data into Power BI.

[Ahmedx]

Refer to this solution

https://community.fabric.microsoft.com/t5/Desktop/Power-BI-Desktop-showing-Empty-Value-in-the-cell-I...

[Sravya_Rajarapu]

I am picking up the data from different sources. But i have tried changing with and without spaces but there was no change. 

[tzvetkov_b87 · Accepted solution]

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. "" 

[Sravya_Rajarapu]

This worked, Changing null to "".

[tzvetkov_b87]

Hi @Sravya_Rajarapu ,

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.