Forum Discussion
Visuals on more than one column
you can try to do the data transform in PQ
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wcs7PLchJLUlNUdJRCkjNS8nMSweyXIuTE3MSS1KVYnVooUQBjLGJEmEqRKNnXjJUljzzKNKCw3JswrEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Completed = _t, Pending = _t, Escalate = _t]),
Custom1 = Table.FromList( List.Combine(Table.ToColumns( Source))),
#"Filtered Rows" = Table.SelectRows(Custom1, each ([Column1] <> " ")),
#"Duplicated Column" = Table.DuplicateColumn(#"Filtered Rows", "Column1", "Column1 - Copy"),
#"Grouped Rows" = Table.Group(#"Duplicated Column", {"Column1"}, {{"Count", each Table.RowCount(_), Int64.Type}})
in
#"Grouped Rows"then it will be easy to draw the pie chart.
Hi Alaska1 ,
Ryan_mayu seems to have provided you with a solution, is it possible to mark his reply as a solution? Also, is there anything else you need help with regarding this thread?
Best Regards
Super Userpls provide some sample data and expected output.
Completed Pending Escalate Completed Pending Escalate Completed Pending Escalate Completed Pending Escalate Completed Completed Escalate Completed Pending Incomplete Completed Escalate Completed Completed Escalate Completed Incomplete Incomplete Thank you!
- ryan_mayu
you can try to do the data transform in PQ
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wcs7PLchJLUlNUdJRCkjNS8nMSweyXIuTE3MSS1KVYnVooUQBjLGJEmEqRKNnXjJUljzzKNKCw3JswrEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Completed = _t, Pending = _t, Escalate = _t]),
Custom1 = Table.FromList( List.Combine(Table.ToColumns( Source))),
#"Filtered Rows" = Table.SelectRows(Custom1, each ([Column1] <> " ")),
#"Duplicated Column" = Table.DuplicateColumn(#"Filtered Rows", "Column1", "Column1 - Copy"),
#"Grouped Rows" = Table.Group(#"Duplicated Column", {"Column1"}, {{"Count", each Table.RowCount(_), Int64.Type}})
in
#"Grouped Rows"then it will be easy to draw the pie chart.
Thank you!
Completed Pending Escalate Completed Pending Escalate Completed Pending Escalate Completed Pending Escalate Completed Completed Escalate Completed Pending Incomplete Completed Escalate Completed Completed Escalate Completed Incomplete Incomplete Thank you!
