Forum Discussion
Line Chart X-axis categories
Hello. Fairly new to PowerBI.
I have survey data that we usually analyze in Excel.
Example of data is attached. Along with 2 charts we usually use to show the data.
I am trying to replicate these charts in PowerBI, but am having trouble figuring out how to input the data fields to achieve the right X- and Y-axis results.
PowerBI dataset basically matches the example, with no other connected data currently.
Do I need to make a connected dataset that just lists the Survey Questions in a single column? If so, how do I connect the data sets?
| Model | Question 1 | Question 2 | Question 3 | Question 4 | Question 5 | Question 6 |
| Vehicle A | 8.297753 | 8.374302 | 8.516854 | 8.480447 | 8.463687 | 7.986755 |
| Vehicle B | 8.542857 | 8.585882 | 8.596698 | 8.689412 | 8.689412 | 8.307494 |
| Vehicle C | 6.5 | 6 | 6.5 | 6 | 6.5 | 3.5 |
Hi souchock ,
Just use unpivot other colums in your table:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
3 Replies
souchock , I think you unpivot to question in rows. Suggesting Based on the Table you shared.
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/Hi souchock ,
Just use unpivot other colums in your table:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thank you. I understand and this generally solves the problem.
is there any tip/trick to shape the data where we have more like 100 survey questions to sort through?
It is annoying to set the filters to only show the particular 10 questions I want at any time in the chart.
Thanks
