Forum Discussion
Pivot Column Results in Null
Hi all,
I have a column Facts that I want to go across the columns. Currently there are 6 columns that should be going down a single column. First, I unpivot the columns into a single column Segment, and everything works as expected. Then, I Pivot on my Facts column, but some of the values are resulting in null. These values exist before I pivot the columns. Additionally, if I filter to a particular Fact before I pivot, some of the values that otherwise become null work.
Any ideas why this could be happening? I've tried with Sum and Don't Aggregate.
Thanks!
Thanks, Greg_Deckler. My apologies, this seemed to be a data issue where the original data source did not process correctly, leading to the surprising result. As always, a good reminder to go back to the source when something unexpected is happening.
3 Replies
msmays5 It's super difficult to know what might be going wrong. Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Thanks, Greg_Deckler. My apologies, this seemed to be a data issue where the original data source did not process correctly, leading to the surprising result. As always, a good reminder to go back to the source when something unexpected is happening.
Hi msmays5 ,
It seems that you have resolved the issue. If so, can you please accept your answer as solution? Then this thread will be closed. Others who have the same questions will find the answer easily and quickly. They will benefit from the thread. Thanks!
