Creating slicer when data is in different columns

[Pri]

I have data in three different columns and I want to create a slicer with this data.

Please suggest a way to do the same.

[mussaenda]

Provide sample data and expected output.

[Pri]

Sample Data :

Total Value	Internal Value	External Value
100	40	60
70	30	40

Expected Output:

Slicer with three options in dropdown : Total Value, Internal Value, External Value

[mussaenda]

Based on your provided data, try this:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQwUNJRMgERZgZKsTrRSuYgtjFUNDYWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Total Value" = _t, #"Internal Value" = _t, #"External Value" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Total Value", Int64.Type}, {"Internal Value", Int64.Type}, {"External Value", Int64.Type}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {}, "Attribute", "Value")
in
    #"Unpivoted Columns"

[Pri]

Where do I need to paste this code? 

[v-frfei-msft · Accepted solution]

Hi @Pri ,

Go to power query as the picture as below.

Then choose all the columns and upivot columns as the picture below.

[mussaenda]

In power Query, Advance Editor.

Delete everything from there and paste the code.

This is based on the data you provided.

Follow the applied steps on your own data to achieve what you needed.