Help with Charts

[emmanmapada]

I need help on my charts. Below is my data:

 

How do I create a chart that when I select Anne - it will show that the skills are Singing and Dancing and the Areas of Interest are Books Movies and Shopping. I created a pie chart but it only shows the line where Anne is at - Singing and Books.

I appreciate the help! 🙂

I

[v-danhe-msft · Accepted solution]

Hi @emmanmapada,

It is decided by your data structure, you could modify your data like below data view:

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

[JonV]

The problem here is how your data is arranged. Power BI doesn't know how to interpret it. It reads row-by-row and in doing so, only comes across each name once. As such, it only displays what's in the row with the name. So by filling in every row with the name, it should fix your issue.

That being said, making charts for this type of data isn't really useful. A chart doesn't convey the information any more quickly or usefully than the original table does.