Forum Discussion
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! 😞 I have tried pivot column (Transform data -> Pivot column) on ColumnB with ...
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 resultI 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?
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?