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...
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.

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

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

     

    • dax's avatar
      dax
      Community Support
      6 years ago

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

        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?