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 value | Some number | Some value | Some number | Some value | Some number | Some value |
| Some number | Some value | Some number | Some value | Some number | Some value | Some number | Some value | Some number | Some value |
The value column contains several unique values that are repeated. How to filter columns of numbers using only these few values.
I'm new to power bi.
Best regards Nowak
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
2 Replies
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 numberSp1value1 Some value And I need to get something like thisValue(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 answerBest regardsNowak
