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.
Actually am not getting anything, specially the code. Is there any way to get started with these queries?
Hi atharvaunde59,
You could click Get Data->Blank Query, then click advance editor and paste below query in it. Or in your sample, you could choose course columns , the click Transform->unpivot column in Edit Queries. Then use attribute and value in chart
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tried it but not working 😞 as am not familier with DAX at all
will it be possible to create one measure if i share my project file here?
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
