Forum Discussion
Inverted column grid possible?
- Anonymous2 years ago
Hi Sakshi_S ,
Based on your description, I created the following test dataIf you want to achieve the effect you want, first click on Transform data and open the power query.
Change the name of date as date.1 and Select the date column and UNpivot the other columns.
Close and apply and create matrix visualFinal output
Of course, you can also open the advance editor and enter the M code into it.let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTUNzTQNzIwMlbSUXJOzMkBUi6ZxamJxakKxSWJJalKsTpAVUb6hhbEqDIygqkKy0xJzceuTN8QpMgEKOlm5AYknYoS81JgUqZ45MxgcjDDobKxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, Channel = _t, #"Topic of dicussion" = _t]), #"Renamed Columns" = Table.RenameColumns(Source,{{"Date", "Date.1"}}), #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Renamed Columns", {"Date.1"}, "Date", "Value") in #"Unpivoted Other Columns"Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Sakshi_S ,
Based on your description, I created the following test data
If you want to achieve the effect you want, first click on Transform data and open the power query.
Change the name of date as date.1 and Select the date column and UNpivot the other columns.
Close and apply and create matrix visual
Final output
Of course, you can also open the advance editor and enter the M code into it.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTUNzTQNzIwMlbSUXJOzMkBUi6ZxamJxakKxSWJJalKsTpAVUb6hhbEqDIygqkKy0xJzceuTN8QpMgEKOlm5AYknYoS81JgUqZ45MxgcjDDobKxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, Channel = _t, #"Topic of dicussion" = _t]),
#"Renamed Columns" = Table.RenameColumns(Source,{{"Date", "Date.1"}}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Renamed Columns", {"Date.1"}, "Date", "Value")
in
#"Unpivoted Other Columns"
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly