Create bar chart by aggregating on string values

[Anonymous]

I am new to PowerBI and I need to create 2 visualization(bar chart) which will show the following:

Chart1--- 3 bars for each of the tag strings(alpha, beta, gama) and the count of customers for each tag string(alpha=5, beta=4, gama=4).

Chart2 --- 3 bars for each of the tag strings(alpha, beta, gama) and the total of value for each tag string(alpha=160, beta=90, gama=100).

Please, help me with how to get this two charts with tutorial. Thanks in advance.

[amitchandak · Accepted solution]

@Anonymous , You can split the column using row split

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Or create a new table in power query using customer and Tags and then split in a new table and join back with customer id.

1. Copy the table and remove columns

2. Select column, Right-click last option, create a new query, and convert to a table.

[MFelix · Accepted solution]

Hi @Anonymous ,

Follow the steps below:

• Select the column Tags
• Split columns
• Advance Rows:

Now just do the charts with the tags on the axis.

Check PBIX file attach and code below:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUXLMKchI1FFwSi1JBPIMDZRidaKVnGASQNoIIuQMZEIVQUVcgEz3xFwkba4I86ASxhAJN1SL4NJQk9yhZsPFTSDiHkjOsAAKxQIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Customer = _t, Tags = _t, Value = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Customer", type text}, {"Tags", type text}, {"Value", Int64.Type}}),
    #"Split Column by Delimiter" = Table.ExpandListColumn(Table.TransformColumns(#"Changed Type", {{"Tags", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Tags"),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Tags", type text}}),
    #"Replaced Value" = Table.ReplaceValue(#"Changed Type1"," ","",Replacer.ReplaceText,{"Tags"})
in
    #"Replaced Value"

[Greg_Deckler]

@Anonymous - Best thing to do would be to split your column by comma in Power Query Editor. Then, unpivot the three resulting columns. At that point, things should be very easy.

[amitchandak · Accepted solution]

@Anonymous , You can split the column using row split

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Or create a new table in power query using customer and Tags and then split in a new table and join back with customer id.

1. Copy the table and remove columns

2. Select column, Right-click last option, create a new query, and convert to a table.

[Anonymous]

@amitchandak  can you please help me show tutorial on how to create the two visualization. I am having the problem with charts.

[amitchandak]

@Anonymous ,Can you share sample data and sample output in a table format? 

covered as thrid item in video -https://www.youtube.com/watch?v=1_XlyzV-PcY&t=31s