Forum Discussion
Creating custom Radar chart
Hi atharvaunde59,
Did you try this in Edit Queries in PowerBI(choose all subjects columns and click unpivot column)? Or you also could transform data structure by query when you load in PowerBI, you could use union all in mysql to unpivot column. You could refer to Unpivot Function for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, if I understand you correctly, it's something like this you want to achieve?
You can go to the marketplace and download the certified "Radar Chart".
You're visual should look something like this:
Let me know if this helps you.
Ok, finally i decided to restructured my data.
Now I want some suggetions for the same. I want to store data exam marks of thousands of students. Each student will be having 50+ columns for marks of different subjects.
Previously i was using all subjects in columns and student name as rows. Is there any better way to make it so i can design spider chart easily?
am using MySQL , is it ok? or should i switch to Mongo?
daxCommunity Support
Hi atharvaunde59,
Did you try this in Edit Queries in PowerBI(choose all subjects columns and click unpivot column)? Or you also could transform data structure by query when you load in PowerBI, you could use union all in mysql to unpivot column. You could refer to Unpivot Function for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.