Plot count of employee against multiple tasks

[TinyElephant]

I have a table of different employees involved in a number of projects. I want to plot the projects as Legends and count of employees against each project in the pie chart.

I am using a slicer for selecting employees because there will be more such data coming for each employee. How can I achieve this?

Employee	Project A	Project B	Project C
John	Y
Derek		Y
Michael	Y		Y
William		Y

[v-easonf-msft]

Hi,  @TinyElephant 

You may need to unpivot your table columns as below:

Best Regards,
Community Support Team _ Eason

[TinyElephant]

I did some workaround for the auto removal of null rows problem as described here.

https://community.powerbi.com/t5/Desktop/Unpivot-removes-rows-with-no-null-values-how-to-keep-them/m... 

But there's another problem. The 'Count of Value' goes into thousands due to the thousands of rows created after all unpivoting columns are done. If I select 'Count of Value (distinct)' filter, it's just 1 or 2.

A simplified version of pbix file is uploaded here

https://drive.google.com/file/d/1ksOVue1bx8eyCCDSnKQuPMJDshnch7kK/view?usp=sharing

[TinyElephant]

Thanks for the response. It works for most parts but Unpivoting Columns removes some entries (rows/names) where it is blank.
e.g. If I have a person who is not working in any of the mentioned projects (blank values), it will be auto removed when using Unpivot Columns. Any suggestion?

[TinyElephant]

I didn't quite get you. New to Power BI. Could you explain a little bit more.

[amitchandak]

@TinyElephant , you can use A, B, C as values or as the measure and use them as values

or unpivot this table and use 

https://radacad.com/pivot-and-unpivot-with-power-bi