Pivot Column Results in Null

[msmays5]

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!

[Greg_Deckler]

@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.

[msmays5 · Accepted solution]

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.

[v-xuding-msft]

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!