Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Sravya_Rajarapu
Regular Visitor

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.

 

Sravya_Rajarapu_1-1703089837381.png

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. 

Sravya_Rajarapu_2-1703089996689.png

 

Can anyone please help me with this. 

 

 

 

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

View solution in original post

6 REPLIES 6

  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
Super User
Super User
Sravya_Rajarapu
Regular Visitor

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

Sravya_Rajarapu_0-1703090864328.png

 

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_0-1703092543672.png

This worked, Changing null to "".

 

Sravya_Rajarapu_1-1703092590019.png

 

tzvetkov_b87
Helper I
Helper I

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.