Merging fields to count as one

[iloobi]

Hello,

I am very new to PowerBI and potentially this is an easy question so my apologies if it seems stupid to ask this. I have data in this format

Project name	Population served (1st choice)	Population served (2nd choice)	Population served (3rd choice)
Dancing	Women and girls	Children and Youth
Singing	Children and youth	Low income individuals	Indigenous
Reading	Indigenous
Writing	Racialized communities	Children and Youth

Right now, when try to build a visualization in desktop, I am only able to count these categories seperately. Like in this decomposition tree, I can only follow the thread of which projects are serving children and youth as first choice, then people living with mental health issues as a second choice, etc. 

Or on this dashboard, I need individual splicers for each choice to be able to filter for each choice

What I would like is to be able to somehow total up each category. So that regardless of which choice it is mentioned at, it would count towards a total. So like in the sample table, Children and Youth are served in 3 different projects in 3 different choices. I want the decomposition table to be able to total that up instead of spliting them by the choice selection. I imagine I will have to create a new field/column somehow in transforming the data but I have no idea how to do that. Could something be comma seperated or semicolon seperated but PowerBI would be able to recognize the individual values?

I tried create true/false columns for each population type but I have over 12 population types listed and couldn't find an easy way to filter on the dashboard without creating 12 different splicers. 

I hope my question makes sense and that someone knows of a work around that would help. 

[iloobi]

@Greg_Deckler Thank you

[Greg_Deckler · Accepted solution]

@iloobi In Power Query Editor, select those 3 columns and then unpivot.