Data filtering

[Nowak]

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

[amitchandak · Accepted solution]

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

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