missing values when unpivoting column

[yarelbelanger17]

I have a data set that has month over month values so I want the months to be columns instead of rows. I have values for all rows, but when I unpivot- I get nulls with some where there should be a number. I only pulled in the data I needed and made sure the format type was correct. Has anyone else had this issue? 

[v-yiruan-msft]

Hi @yarelbelanger17 ,

Whether your problem has been resolved?

Best Regards

Rena

[amitchandak]

Can you go to visualization and create a pivot in matrix and and check the values. I doubt, mutiple rows has been created during unpivot. Ans some of them have 0 values.

[v-yiruan-msft]

Hi @yarelbelanger17,

Could you please provide the related table structure and some sample data in this table? And please also provide the applied step script for Unpivot(see below screenshot). Thank you.

Best Regards

Rena

[VasTg]

@yarelbelanger17 

Provide some sample data.. I could not simulate the error. I have seen it in the past and vaguely remember it was a datatype issue. Maybe convert them to text and unpivot..