Forum Discussion
Building Dashboard for multiple organizations
Hey all, Im working at a research institute that conducts surveys for clients. Our DB is built like this: Organization Key Name Date Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 ...
nvprasad
Solution Sage
Solution SageHi,
In the PowerQuery editor, you can pivot the questions & responses into two columns. This means all the questions should come under one column and answers should come in the next column.
This way you can slice and dice information as you needed.
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad
hey nvprasad ,
It's a really good idea!
And how would you cross between organizations? A page navigation to the organization?
Is this means that we'll need to build a report for each organization?