Forum Discussion
Showing Likert Scale data in one table
"Do i need to format my data a different way?" Yes
service extremely satisfied satisfied dissatisfied Extremely dissatisfied Service 1 1 23 4 7 Service 2 3 12 5 2 service 3 1 4 5 7 Powerbi can manipulate data in all sorts of ways. However, make it easy on yourself, get the data in a format that means you can concentrate on easily making/designing/altering the visualisations. Don't get to the report page in powerbi with long lists of text values that need to be manipulated differently for different visualisations
Powerbi works best with aggregations.
That picture you posted can't be anything like your real data. Individual responses to each service are all the same and there's one more response in each column than the one before. If i'm wrong, i apologise.
Try and get your data in the format i've shown. If you can't then
post some masked data (not a picture of it), i'll put it in a pbix and send a link back to you
My data is as follows (i have simplified)
I have tried the clustered graph, however:
- pull service 1 into Axis and value - this looks fine.
- When I try to pull service 2 into value the count changes - and the same when i pull in the rest (service 3-6). The count value doesnt show the right counts.
So confused! Do i need to format my data a different way?
"Do i need to format my data a different way?" Yes
| service | extremely satisfied | satisfied | dissatisfied | Extremely dissatisfied |
| Service 1 | 1 | 23 | 4 | 7 |
| Service 2 | 3 | 12 | 5 | 2 |
| service 3 | 1 | 4 | 5 | 7 |
Powerbi can manipulate data in all sorts of ways. However, make it easy on yourself, get the data in a format that means you can concentrate on easily making/designing/altering the visualisations. Don't get to the report page in powerbi with long lists of text values that need to be manipulated differently for different visualisations
Powerbi works best with aggregations.
That picture you posted can't be anything like your real data. Individual responses to each service are all the same and there's one more response in each column than the one before. If i'm wrong, i apologise.
Try and get your data in the format i've shown. If you can't then
post some masked data (not a picture of it), i'll put it in a pbix and send a link back to you