cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
emmanmapada Frequent Visitor
Frequent Visitor

Help with Charts

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

 

Capture2.PNG 

 

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! Smiley Happy

 

ICapture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Help with Charts

Hi @emmanmapada,

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

1.PNG

Result:

1.PNG

 

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

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
JonV Frequent Visitor
Frequent Visitor

Re: Help with Charts

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.

Community Support Team
Community Support Team

Re: Help with Charts

Hi @emmanmapada,

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

1.PNG

Result:

1.PNG

 

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

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.