Unpivot columns with question scores roll up

[jcastr02]

I have a query with team member names and the individual breakout of each question score from a module.  M1-P35 (module 1, question 35)   M2-P1 (Module 2, question 1)........I'd like to be able to have a filter for each module 1, 2, 3, 4, 5, 6 and a filter by team member and final chart should show the scores for each question within each module.  Which columns should I unpivot to achieve this, having difficulty with it knowing which module it belongs to.       

[v-alq-msft]

Hi, @jcastr02 

Based on your description, i create data to reproduce your scenario.

You can click ‘Edit Query’, go to Query Editor, choose related columns,go to ‘Transform’ pane, execute ‘unpivot other columns’, rename the Attribute column. Don't forget to click the "Close & Apply" button.

 

Result:

If I misunderstand the your thoughts, please show us your  expected output. I am glad to solve the problem for you.

Best Regards,

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jcastr02]

Thank you Allan for your help.  The filter would actually be the module number, so I'd like to be able to tie each of the attributes not sure if this would require me to another column after unpivoting?      So if i filter for module 2, then only M2-P1, M2-P2, etc. would show up in the visual.  @v-alq-msft