Forum Discussion
Separating values in a field for a count visual
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
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".
4 Replies
- bhanu_gautam
Super User
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".
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
I was able to use the reference feature to create new table for your suggested count function. Thank you bhanu_gautam
