Separating values in a field for a count visual

[cmcnally]

Hi All,

Apologies if this has already been answered, I struggle to describe what I'm trying to do well enough to search the forum.

I have a PowerBi report that has a list of events taken from 2 different sources, a sharepoint list and a web XML feed. I'm using PowerBi to transform and merge the data. One of the fields I have is for audience and can contain multiple values separated by the pipe character "|".

How can I visual the counts of the individual audience categories?

Thanks

C

[bhanu_gautam · Accepted solution]

@cmcnally ,

In Power Query Editor, select the audience column.
Click on "Split Column" > "By Delimiter".
Choose | as the delimiter and select "Split into Rows".
Group By Audience:

Click on "Group By" in the Home tab.
Group by the audience column and add a new column with the operation "Count Rows".
Load Data:

Click "Close & Apply".

[cmcnally]

Thanks for your reply. Will splitting into rows cause duplicate entries for other visuals in the report? I'm a safer making a dupilcate table/query for that specific visual and would that cause performance issues with the Power Bi report? Thanks

[cmcnally]

I was able to use the reference feature to create new table for your suggested count function. Thank you @bhanu_gautam 

[bhanu_gautam]

@cmcnally  You are welcome