using Power Bi for a friendly competition at work

[Anonymous]

Hi Everyone,

So I am creating a competition at work where I send out a simple Microsoft form with 10 questions to all the teams. Each team will receive the questionnaire and respond. I have worked out how to send out the questionnaire to everyone and using power automate record their response in power BI. However this inputs all thier responses all together.

I would like the 20 teams  (6 responses each) to be shown seperately in a dashboard  in a line graph each in order to compare, however im not sure how to seperate them.

Can anyone tell me how you go about this or if any of you have any alternative ideas i am open to suggestions. Thanks Everyone!🙂

[collinq · Accepted solution]

Hey @Anonymous ,

The quickest and easiest way that I think of is to add the Team Name to the questionnaire and then use that as the filter/slicer/category or whatever you need it as to separate the results.  That will allow you all sorts of slice and dice capability - because you will be able to roll with the team and/or the question number.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!