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