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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
kylee_anne
Helper II
Helper II

Fill Down Problem

My data is imperfect and I have a column containining area and discipline values.  So I can keep both I thought if I copied the column, replaced discipline with blank or null, then filled down I could get the area too.  As steps in Power Query.  But it's not working.  I can't replace with either discipline or blanks with null and I can't fill down.  What am I missing?

1 ACCEPTED SOLUTION
slorin
Super User
Super User

Hi,

Add a new column

if Text.StartsWith([WBS], "WBS") then [WBS] else null

 or

if [Level]<3 then [WBS] else null

 then Fill Down

 

Stéphane

View solution in original post

4 REPLIES 4
slorin
Super User
Super User

Hi,

Add a new column

if Text.StartsWith([WBS], "WBS") then [WBS] else null

 or

if [Level]<3 then [WBS] else null

 then Fill Down

 

Stéphane

Thanks.  Just for my understanding so if I add a little code to Power Query it works.  If I try to do it all visually it doesn't.  Does it always work this way?

kylee_anne
Helper II
Helper II

OK.

 

kylee_anne_0-1701069914953.png

Sorry I just snipped a bit.  WBS covers area and discipline so I want to copy that column, remove discipline labels and fill down WBS.  And I can't, even if I do multiple steps.  Replace CIV,SMP, E&I with blank, replace blank with null then fill down.  Ideas?  I then unpivot so ultimately I'm looking at histograms over time and I can filter by area or discipline.

PijushRoy
Super User
Super User

Hi @kylee_anne 

Could you please share a screenshot of the issue? Please share some sample data as excel format (not sensitive)




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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