Forum Discussion
Separating values in a field for a count visual
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 ,
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
cmcnally You are welcome