Calculate Percentage of feature supported by product offerings

[Anonymous]

Hello Everyone -

I am trying to build a report where I need to compare the number of features that we have and the solutions offered by potential product vendors.

Looking at the report, I should be able to make out what is the percentage of features supported by each of the product.

My raw data looks somewhat like below:

Features	Feature description	Product A supports	Product B Supports
Feature A	sample text	Yes	No
Feature A	sample text	Partially Yes	Partially Yes
Feature A	sample text	No	No
Feature B	sample text	Partially Yes	Yes
Feature B	sample text	Partially Yes	Yes
Feature B	sample text	Yes	Yes
Feature B	sample text	Yes	No
Feature C	sample text	No	No
Feature C	sample text	No	No

My Report should look in the form of bar or pie digram:

So that I can do a side by side comparison of the product offerings against each feature.

Report
	Total Features A	100		Total Features B	90		Total Features C	50
	Product A Supports features	40%		Product A Supports features	40%		Product A Supports features	40%
	Product A partially Supports	30%		Product A partially Supports	30%		Product A partially Supports	30%
	Product A doesn't support	30%		Product A doesn't support	30%		Product A doesn't support	30%
	Total Features B	100%		Total Features B	100%		Total Features B	100%
	Product B Supports features	50%		Product B Supports features	50%		Product B Supports features	50%
	Product B partially Supports	30%		Product B partially Supports	30%		Product B partially Supports	30%
	Product B doesn't support	20%		Product B doesn't support	20%		Product B doesn't support	20%

Thanks for the help.

[v-lili6-msft]

hi, @Anonymous 

You may need to Unpivot the raw data in Edit Queries:

Select Product A supports, Product B supports... then unpivot the columns in these columns.

https://support.office.com/en-gb/article/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

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

Best Regards,

Lin