Forum Discussion
Bar chart for categorical data count
Solution SageYour best option is to split the 2nd column at the ", " and create a list, then expand that to new rows. You can then easily create your visual. Here's one way to do it in the query editor. To see how it works, just create a blank query, open the Advanced Editor and replace the text there with the M code below.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjBMS0s1UNJRCkpNTNFRCC/KLEnVUXAsKCjKL0tVitWJVjJJTEoygSoAC5hVZiRbGAFFoKqgusByBkapaYlpQDmEkGFScpppCqoNSrGxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [UserID = _t, Roles = _t]),
#"Added Custom" = Table.AddColumn(Source, "Custom", each Text.Split([Roles], ", ")),
#"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom"),
#"Removed Columns" = Table.RemoveColumns(#"Expanded Custom",{"Roles"})
in
#"Removed Columns"
Pat
- ichavarria
Solution Specialist
Hi asheet_s,
I support ppm1. This would work. Please give it a try and feel free to reach back if you need any additional help.
Best regards,
Isaac Chavarria
If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quicklyHi ppm1 ichavarria
Thnaks for the repsonse. One question - Where to insert the table name?
If I have a table named [X_ROLE_CLASS], where should that name be placed?- ppm1
You shouldn't need the table name. In the query editor, the key step is the #"Added custom" one where you reference your Roles column inside Text.Split.
Pat
