Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |