Forum Discussion
Solved
Creating slicer when data is in different columns
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.
Hi Pri ,
Go to power query as the picture as below.
Then choose all the columns and upivot columns as the picture below.
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"
Where do I need to paste this code?
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.
Hi Pri ,
Go to power query as the picture as below.
Then choose all the columns and upivot columns as the picture below.