Visuals on more than one column

Alaska1 

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