Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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://radacad.com/pivot-and-unpivot-with-power-bi
Best Regards,
Lin
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |