Forum Discussion

atharvaunde59's avatar
atharvaunde59
Frequent Visitor
6 years ago
Solved

Creating custom Radar chart

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 

Need Help
  • dax's avatar
    dax
    6 years ago

    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.

12 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      atharvaunde59
      Frequent Visitor
      6 years ago

      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's avatar
        dax
        Community Support
        6 years ago

        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's avatar
      atharvaunde59
      Frequent Visitor
      6 years ago

      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's avatar
        dax
        Community Support
        6 years ago

        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.