Bar chart to show form responses for multiple users

[Gowmadrid82]

Hi,

I am collecting feedback responses from Microsoft Forms and storing those into SharePoint and would like to report on those using a bar chart. The questions are mainly 'yes', 'no' or 'no basis to respond' answers, except the last question which has Excellent, Good, Satisfactory etc... There will be multiple responses for the same user, for example x number of people may provide feedback for the same person. Each question in the form is a column in a table. I have unpivoted all columns with the exception of the column that contains the person receiving feedback. 

I am able to create a bar chart that shows each question and the number of responses by the person receiving the feedback (there will be 4 in total), although I am struggling to figure out how to show how whether they answered 'yes', 'no' or 'no basis to respond' for each question and for each person receiving feedback. 

Below is a table showing the data, the first column is the summer associate receiving the feedback, the second is the attribute showing the question and the last is the value whether it is 'yes', 'no' or 'no basis to respond'. I have used a clustered bar chart, set the x-axis as the attribute, the y-axis as the value and the legend as the summer associate. 

Any ideas on best way to get the visual to also show the actual value e.g. 'yes', 'no' or 'no basis to respond'? Rather than it just counting the number of rows for each question

[Gowmadrid82]

Ignore my last post regarding the measure to colour code, I have colour coded it using a switch and conditional formatting

Response Colour =

VAR ResponseColour = SELECTEDVALUE('Evaluation unpivoted'[Value])

RETURN

SWITCH(TRUE(),

ResponseColour = "Yes", 1,

ResponseColour = "No", 2,

ResponseColour = "No Basis To Respond", 3,

ResponseColour = "Excellent", 4,

ResponseColour = "Good", 5,

ResponseColour = "Satisfactory", 6,

ResponseColour = "Fair", 7,

ResponseColour = "Poor", 8

)

[Gowmadrid82 · Accepted solution]

Thank you Ashish and Ibendin for your suggestions. I have had a look at the custom visuals and whilst they can use both data points, visually I don't believe it will present the data that the user wants. 

I have managed to get the data as I want (to a certain degree by adding attribute and value to the x-axis (see below) with the legend showing as the associate

@Ashish_Mathur - I have tried your solution and using the slicer could work and I will present this to the requestor as an option. Although I do think they will prefer to have the quetsions separated out rather than the responses using the legend to present the questions as it is hard to digest the questions they have answered. Below is how your suggestion looks

What I might do is have the attribute and value as the x-axis and then the count of value as the y. Remove the Legend completely (otherwise I cannot colour code the yes as green, no as red etc...) and then use the slicer as you suggested to view based on associate. (see below) If I do that, will I need to create a measure to apply the conditional formatting to show yes as green, no as red, no basis to respond as amber? 

[Ashish_Mathur]

Hi,

How about creating a slicer for Agent an d dragging Attribute to the Legend instead.

[lbendlin]

You cannot cluster AND stack with the standard column chart.  You can use Deneb or Charticulator to create a chart that has both.

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.