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
junmin
Frequent Visitor

Pivot and Null Values

Hi all!

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

powerbi.PNG

 

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: 

powerbi2.PNG

 

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!! 😞

2 ACCEPTED SOLUTIONS
RaulB
Frequent Visitor

For me it worked using Pivot.
This is the data I used:
Capture3.PNG
Then I used pivot column on ColumnB with values from ColumnC
Capture.PNG
And this is the result
Capture2.PNG

View solution in original post

rayzrbk
New Member

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

rayzrbk_0-1697665560694.png

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

rayzrbk_1-1697665615496.png

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?

View solution in original post

2 REPLIES 2
rayzrbk
New Member

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

rayzrbk_0-1697665560694.png

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

rayzrbk_1-1697665615496.png

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?

RaulB
Frequent Visitor

For me it worked using Pivot.
This is the data I used:
Capture3.PNG
Then I used pivot column on ColumnB with values from ColumnC
Capture.PNG
And this is the result
Capture2.PNG

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.