Recreate a forms chart with multiple answers in powerbi desktop

[UK_PBI]

I have a challenge similar to this issue https://community.fabric.microsoft.com/t5/Desktop/Recreate-a-office-forms-chart-in-powerbi-desktop/t... however I have 8 questions in the form, which each have 3 possible answers. I need to combine two sets of data, and the only way to do this is Power BI (but if you know how to add from one survey in MS Forms into another that may be better!). The responses look like this in Forms:

There are separate questions that have been unpivoted to create multiple rows for one respondent in the Power BI data set. I have tried using measures to count each number of responses for each question, then got stuck on trying to show I use A and I use B together. Does anyone know the tricks to a) easily sum the responses, rather than create a measure for each question and each possible response and b) to represent them on a chart like the one shown here?

[UK_PBI]

Thanks lbendlin that gave me a great help. I had to modify the measures slightly to get the right outcome for the weights, as it was only giving back the max of 1 for everything, but you put me on the right track and helped me with the formulae needed: very much appreciated.
e.g. mod of Never to be Never2 = CALCULATE([Value],'Table'[Response]="Never / Not Applicable", Weights[Response]="Never / Not Applicable")

[UK_PBI]

Thanks @lbendlin I've not pasted in before so hopefully this will work:

ID	I use A	I use B	I use C	I use D	I use E	I use F	I use G	I use H	Other Data
1	Sometimes / Rarely	Never / Not Applicable	Sometimes / Rarely	Sometimes / Rarely	Never / Not Applicable	Never / Not Applicable	Usually / Often	Usually / Often	A;B;C
2	Usually / Often	Never / Not Applicable	Never / Not Applicable	Never / Not Applicable	Usually / Often	Usually / Often	Never / Not Applicable	Never / Not Applicable	B;D
3	Usually / Often	Never / Not Applicable	Never / Not Applicable	Sometimes / Rarely	Sometimes / Rarely	Sometimes / Rarely	Never / Not Applicable	Never / Not Applicable	A;C;G
4	Usually / Often	Never / Not Applicable	Never / Not Applicable	Sometimes / Rarely	Sometimes / Rarely	Never / Not Applicable	Never / Not Applicable	Never / Not Applicable	D;B;F
5	Usually / Often	Never / Not Applicable	Never / Not Applicable	Sometimes / Rarely	Never / Not Applicable	Never / Not Applicable	Never / Not Applicable	Never / Not Applicable	B;C;E;G
6	Usually / Often	Never / Not Applicable	Never / Not Applicable	Usually / Often	Never / Not Applicable	Sometimes / Rarely	Never / Not Applicable	Never / Not Applicable	A
7	Usually / Often	Never / Not Applicable	Never / Not Applicable	Never / Not Applicable	Usually / Often	Never / Not Applicable	Never / Not Applicable	Never / Not Applicable	F
8	Usually / Often	Never / Not Applicable	Sometimes / Rarely	Sometimes / Rarely	Usually / Often	Never / Not Applicable	Never / Not Applicable	Never / Not Applicable	C;F;G
9	Usually / Often	Sometimes / Rarely	Usually / Often	Never / Not Applicable	Usually / Often	Never / Not Applicable	Never / Not Applicable	Never / Not Applicable	A;B;F
10	Usually / Often	Never / Not Applicable	Never / Not Applicable	Usually / Often		Sometimes / Rarely	Never / Not Applicable	Never / Not Applicable	B;D;E;F

[lbendlin · Accepted solution]

There's a bug in the bar chart visual that ignores the desired sort order. You  would need to use custom chart types.

[lbendlin]

Split "Sometimes/Rarely" into halves, slap a minus on one of them, and give them the same color.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...