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.
| 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 |
| 1 | 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 |
Ashish_Mathur This is my data.
I am using a slicer on name to fetch data of each student into individual cards.
On the same page I want to add spider chard which will show marks of that selected student (from slicer on same).
Like Discrete_Mathamatics_OE,Discrete_Mathamatics_TH, Discrete_Mathamatics_OE_TH etc.... on different axis