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,
Share some data and show the expected result.
Ashish_Mathur this is my data
| No | Seat_No | Name | Discrete_Mathematics_OE | Discrete_Mathematics_TH | Discrete_Mathematics_OE_TH | Discrete_Mathematics_TW | Discrete_Mathematics_OR | Discrete_Mathematics_PR | Discrete_Mathematics_Tot | Discrete_Mathematics_Crd | Discrete_Mathematics_Grd | Discrete_Mathematics_Crd_Pts | Discrete_Mathematics_Grd_Pts | DELD_OE | DELD_TH | DELD_OE_TH | DELD_TW | DELD_OR | DELD_PR | DELD_Tot | DELD_Crd | DELD_Grd | DELD_Crd_Pts | DELD_Grd_Pts | DSA_OE | DSA_TH | DSA_OE_TH | DSA_TW | DSA_OR | DSA_PR | DSA_Tot | DSA_Crd | DSA_Grd | DSA_Crd_Pts | DSA_Grd_Pts | COA_OE | COA_TH | COA_OE_TH | COA_TW | COA_OR | COA_PR | COA_Tot | COA_Crd | COA_Grd | COA_Crd_Pts | COA_Grd_Pts | OOP_OE | OOP_TH | OOP_OE_TH | OOP_TW | OOP_OR | OOP_PR | OOP_Tot | OOP_Crd | OOP_Grd | OOP_Crd_Pts | OOP_Grd_Pts | DELD_LAB_OE | DELD_LAB_TH | DELD_LAB_OE_TH | DELD_LAB_TW | DELD_LAB_OR | DELD_LAB_PR | DELD_LAB_Tot | DELD_LAB_Crd | DELD_LAB_Grd | DELD_LAB_Crd_Pts | DELD_LAB_Grd_Pts | DSA_LAB_OE | DSA_LAB_TH | DSA_LAB_OE_TH | DSA_LAB_TW | DSA_LAB_OR | DSA_LAB_PR | DSA_LAB_Tot | DSA_LAB_Crd | DSA_LAB_Grd | DSA_LAB_Crd_Pts | DSA_LAB_Grd_Pts | OOP_LAB_OE | OOP_LAB_TH | OOP_LAB_OE_TH | OOP_LAB_TW | OOP_LAB_OR | OOP_LAB_PR | OOP_LAB_Tot | OOP_LAB_Crd | OOP_LAB_Grd | OOP_LAB_Crd_Pts | OOP_LAB_Grd_Pts | Soft_Skills_OE | Soft_Skills_TH | Soft_Skills_OE_TH | Soft_Skills_TW | Soft_Skills_OR | Soft_Skills_PR | Soft_Skills_Tot | Soft_Skills_Crd | Soft_Skills_Grd | Soft_Skills_Crd_Pts | Soft_Skills_Grd_Pts | Audit_Course_Grade | SGPA | Percentage | Result | Class |
| c | S150334201 | A M PRAJWAL | 28 | 27 | 55 | NA | NA | NA | 55 | 4 | B+ | 7 | 28 | 27 | 20 | 47 | NA | NA | NA | 47 | 4 | C | 5 | 20 | 22 | 20 | 42 | NA | NA | NA | 42 | 4 | P | 4 | 16 | 20 | 20 | 40 | NA | NA | NA | 40 | 4 | P | 4 | 16 | 18 | 27 | 45 | NA | NA | NA | 45 | 4 | C | 5 | 20 | NA | NA | NA | 20 | NA | 30 | 67 | 1 | A | 8 | 8 | NA | NA | NA | 21 | NA | 25 | 61 | 2 | A | 8 | 16 | NA | NA | NA | 20 | NA | 38 | 77 | 1 | A+ | 9 | 9 | NA | NA | NA | 21 | NA | NA | 84 | 1 | O | 10 | 10 | PP | 0 | 0.00 | Fail | Fail |
am using a slicer on the name field so that on choosing name from slicer, it fetches data of that selected student in the individual cards
on same page i want to add spider chart while will have following sub
Discrete_Mathamatics_OE
Discrete_Mathamatics_TH
Discrete_Mathamatics_OE_TH etc ....
on different axis so that it will show marks of the student whose name is selected from the slicer
Hi,
I do not understand your requirement. Perhaps someone else will help you.