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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Fill down a column that is text not working, need help to trouble shoot

I have two columns I need to fill down. One column is numeric and it fills down fine (Column6 below). The other column is text but it won't fill down (Column1 below). Does the fill down not work with text? Is there another work around?

 

filldown 2.png

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous ,

Please replace the value " " in Column1 with null, and then fill the value down to check if works well...

1. Replace the value " " in  Column1 with null (select "Column1",right click and choose "Replace Values...")

replace value.JPG

2. Fill the value down after replaced the value (select "Column1",right click and choose "Fill"-->"Down")

fill down.jpg

Best Regards

Rena

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Hi @Anonymous ,

Please replace the value " " in Column1 with null, and then fill the value down to check if works well...

1. Replace the value " " in  Column1 with null (select "Column1",right click and choose "Replace Values...")

replace value.JPG

2. Fill the value down after replaced the value (select "Column1",right click and choose "Fill"-->"Down")

fill down.jpg

Best Regards

Rena

Thank you very much. Quick as a flash!

Anonymous
Not applicable

Thank you so much as this worked, I was spending hours on this!

Greg_Deckler
Community Champion
Community Champion

I can't get it to work in a text column.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Nishantjain
Continued Contributor
Continued Contributor

@Anonymous 

 

The fill down works if the cells the empty. Looking at the screenshot, it seems they are not empty but whitespace. Usually, the empty cells are shown as null. To get around it, try the following in Column1

 

  1. Use "Replace value" option with following options
    1. Value to find =  ""
    2. Replace with =  null (without any quotes)
  2. Now try to fill down

Thanks

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors