Forum Discussion
Solved
Data filtering
Hi, I have a column with data as below. Sp1num1 Sp1value1 Sp1num2 Sp1value2 Sp1num3 Sp1value3 Sp1num4 Sp1value4 Sp1num5 Sp1value5 Some number Some value Some number Some valu...
Nowak , I think it case of double unpivot
check
Double Unpivot and Reshape Data for Analysis in Power BI| Unpivot Column Set: https://www.youtube.com/watch?v=Diazpx1Nfec&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=1
Nowak , I think it case of double unpivot
check
Double Unpivot and Reshape Data for Analysis in Power BI| Unpivot Column Set: https://www.youtube.com/watch?v=Diazpx1Nfec&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=1
Hi amitchandak ,
Something like this, but when using this function the table is displayed like this.
| Attribute | Value |
| Sp1num1 | Some number |
| Sp1value1 | Some value |
And I need to get something like this
| Value(Col title) | Number (Col Title) |
| Value1 | 1231 |
| Value2 | 3214 |
| Value1 | 1231 |
| Value2 | 1 |
Something like that. I do not know how to do this. Thanks for the answer
Best regards
Nowak