Chart using answers from multiple questions

[Mercer77]

Hi all,

I have this project I am working on and I came accross an issue that I would easily sort in a pivot table but not in PowerBi

The data comes from a survey with multiple questions (about 10) each one of them being a rating of 0 to 10. I would like to create a line chart using the percentage (%) of those who answered 9 or 10 for each question. Say X axis would have the question names (Q1, Q2 ...Q10), and Y axis would be the % of those who answered  9 and 10 for each one of them.

I created a column that calls the 9 and 10, which I am going to use to calculate the percentage for each of them by creating a new measure.

I am wondering if this is the best way, or is there another way to do it?I am thinking maybe creating a table with the calculated values and take it from there?

thanks a lot in advance

[v-xjiin-msft]

Hi @Mercer77,

In my opinion, if you can create a table with the calculated percentage vaules in like SQL Server database and then import the table into Power BI. It will be easier than creating a measure in Power BI desktop.

Thanks,
Xi Jin.