Single drop down slice for different bar chart visualization of each field

kat_pbi So in general you are going to want everything to be unpivoted so that you wend up with a single column with your questions in it and another column with your answers. I don't see the full dataset so hard to tell you exact steps in Power Query. Alternatively you could have a disconnected table with your questions in it but that is going to make the calculations far more difficult.

So like:

ResponseID,QuestionID,QuestionText,Score

1,Question1,This is a question,10

1,Question2,This is another question,3

2,Question1,This is a question,10

2,Question2,This is another question,3

3,Question1,This is a question,10

3,Question2,This is another question,3

You do NOT want:

ResponseID,Question1Text,Question1Score,QuestionIDText,Question2Score,Question3Text,Question3Score...

Not sure how much more specific I can be given the information. @ me in replies.