Creating custom Radar chart

[atharvaunde59]

Hello Community,

Am new to PowerBI and looking forwward to create a custom Radar chart using custom visual published by Microsoft.

👆this is how my data structure looks like.

I want to create a chart in which different subjects like (Discrete_Mathematics_OE, Discrete_Mathematics_TH, Discrete_Mathematics_OE_TH) will be on axis and the marks scored by the student will be shown on them.

Is it possible?

because of some constraints i cant change the structure of the data as have almost 60 columns and 250+ rows.

Any help will be appriciated 

[Anonymous]

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.

[atharvaunde59]

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?

[dax · Accepted solution]

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 Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[atharvaunde59]

My bad, i forgot to add detailed issue in my OP.

actually i am using a slicer that selectes marks and shows into cards after seletcting name as below

now as per your instructions i added slicer there but it is showing something like this 

I'm unable to remove that "count / first" of that variable. Am i missing something?

The arrtibutes that am trying to add except Name are set as 

is my issue related to this formatting ? 

[dax]

Hi atharvaunde59,

You could convert table structure like below by M code and use chart like below

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlTSUTI1BRJmFkDCwlQpVidaKQnCBAqCCEsDsGAykGkO4pubg6SNwYIpIEUGIL4hiDBSio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [name = _t, #"course A" = _t, #"course B" = _t, #"course C" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"name", type text}, {"course A", Int64.Type}, {"course B", Int64.Type}, {"course C", Int64.Type}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"name"}, "Attribute", "Value")
in
    #"Unpivoted Columns"

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.

[atharvaunde59]

Actually am not getting anything, specially the code. Is there any way to get started with these queries?

[dax]

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.

[atharvaunde59]

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?

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[atharvaunde59]

@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 

[Ashish_Mathur]

Hi,

I do not understand your requirement.  Perhaps someone else will help you.

[atharvaunde59]

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