Building Dashboard for multiple organizations

[Anonymous]

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
44	SomeKey	Person1	28/06/2020	3	2	5	5	4	4	3	3	3	2
44	SomeKey	Person2	28/06/2020	3	2	2	1	2	1	5	1	5	5
44	SomeKey	Person3	28/06/2020	5	2	5	4	1	2	2	2	2	2
60	SomeKey	Person4	28/06/2020	1	5	5	1	3	5	4	5	4	4	3	5
60	SomeKey	Person5	28/06/2020	2	5	5	5	5	4	3	2	4	1	5	5
55	SomeKey	Person6	28/06/2020	1	1	3	2	1	4
55	SomeKey	Person7	28/06/2020	4	3	2	4	3	4
55	SomeKey	Person8	28/06/2020	4	1	3	2	2	5
55	SomeKey	Person9	28/06/2020	4	3	2	3	4	4

The DB built that when each survey is made up of a different number of questions as you can see, and of course every question is different from the previous one.

The separation of customers is done by an organization code that appears in the first column.

Organization = A company that pays us for a survey service
How would you recommend building a report for each company? It seems that an organization's filter can't help because each question presents something different.

And of course - each organization should not see the other's results.

Thank!

[nvprasad]

Hi,

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

[Anonymous]

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? 

[nvprasad]

Hi,

Since information needs to be shared only with the respective organizations of their data.

 Below are the options in my mind and the option is my pick.

1. We can build a single report and use Row Level Security to allow users to see only their data.

2. Build multiple reports and share them with the respective organization.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad