To prepare for this recipe, do the following:
- Open Power BI Desktop.
- Use an Enter Data query to create a table called R03_Table with the following data:
|
Employee |
Question |
Answer |
|
1 |
1 |
5 |
|
1 |
2 |
5 |
|
1 |
3 |
5 |
|
2 |
1 |
4 |
|
2 |
2 |
4 |
|
2 |
3 |
4 |
|
3 |
1 |
3 |
|
3 |
2 |
3 |
|
3 |
3 |
3 |
|
4 |
1 |
2 |
|
4 |
2 |
2 |
|
4 |
3 |
2 |
|
5 |
1 |
1 |
|
5 |
2 |
1 |
|
5 |
3 |
1 |
|
6 |
1 |
4 |
|
6 |
2 |
3 |
|
6 |
3 |
2 |
|
7 |
1 |
2 |
|
7 |
2 |
3 |
|
7 |
3 |
4 |
|
8 |
1 |
3 |
|
8 |
2 |
2 |
|
8 |
3 |
2 |
|
9 |
1 |
4 |
|
9 |
2 |
3 |
|
10 |
2 |
3 |
|
10 |
3 |
4 |
The data in this table represents ten separate responses to the three survey questions, although not all questions were answered by all survey responders.