Line Chart X-axis categories

[souchock]

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

[souchock]

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 

[v-deddai1-msft · Accepted solution]

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

[amitchandak]

@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/