Pivot and Null Values

[junmin]

Hi all!

I am relatively new to Power BI, and would really appreciate it if you guys could help me with this! 😞 

I have tried pivot column (Transform data -> Pivot column) on ColumnB with values from ColumnC, which actually gave me close enough to what I want but I am having problem with dealing with the null values that come with it: 

I cannot use replace null values directly because the replacement should follow the corresponding values (it has to be under the same date, and then replace the null values with the non-null value in the same column) I have also tried Fill down and Fill up for Column Question1 and Column Question3 but this will not work for Column Question2.

Should I not be using Pivot? What other solutions would you all suggest?

I hope my question makes sense!! 😞

[Anonymous · Accepted solution]

For me it worked using Pivot.
This is the data I used:

Then I used pivot column on ColumnB with values from ColumnC

And this is the result

[MeggieD00dles]

I know this question is a few years old, but I was just having the same issue and was frustrated that the accepted "answer" here doesn't actually answer anything. I found out through trial and error that the table I was pivoting from had too many columns of data which was throwing the pivot function off and leading to multiple rows and null values. To fix this, I duplicated the original dataset and deleted every column except those being pivoted and an ID column I could use to relate to the original dataset. Make sure you apply the changes then go to Model View to create a two-way relationship between the IDs.

[Tgal_van_die_1]

I don't see how this is the solution to the question

[rayzrbk · Accepted solution]

I have the same problem, and using the sum feature, I get null as my values. I start with 

And then when I pivot the Yield Item column, I get

It pulls the values for the first column, but then every other column that is added from the pivot step shows as null. Any ideas?

[Anonymous · Accepted solution]

For me it worked using Pivot.
This is the data I used:

Then I used pivot column on ColumnB with values from ColumnC

And this is the result