Transpose table for radar graph

[DionTN]

I want to make a radar chart but can not make it because of my format of the tables.

My columnnames are the "categories" but i have more columnes and because of filters i can not change it hard code.

See picture. Can anyone tell me how i can combine BodyComposition to the category body, cardio to cardio and so on?

[lbendlin]

Read about unpivoting your source data to make it usable.

Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[DionTN]

Unfortunately I can not provide you the dataset.

I have input table the one below:

What i need is the mean of a few columns (with filters) in this structure:

[lbendlin]

"Unfortunately I can not provide you the dataset."

 I cannot help you without usable sample data.

[DionTN]

Drive 

[lbendlin · Accepted solution]

let
    Source = <your source>,
    #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter(";", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3", "Column1.4", "Column1.5", "Column1.6", "Column1.7", "Column1.8", "Column1.9", "Column1.10", "Column1.11", "Column1.12", "Column1.13", "Column1.14", "Column1.15", "Column1.16", "Column1.17", "Column1.18", "Column1.19", "Column1.20", "Column1.21", "Column1.22", "Column1.23", "Column1.24", "Column1.25", "Column1.26", "Column1.27", "Column1.28", "Column1.29", "Column1.30", "Column1.31", "Column1.32", "Column1.33", "Column1.34", "Column1.35", "Column1.36", "Column1.37", "Column1.38", "Column1.39", "Column1.40", "Column1.41", "Column1.42", "Column1.43", "Column1.44", "Column1.45", "Column1.46", "Column1.47", "Column1.48", "Column1.49", "Column1.50", "Column1.51", "Column1.52", "Column1.53", "Column1.54", "Column1.55", "Column1.56", "Column1.57", "Column1.58", "Column1.59", "Column1.60", "Column1.61", "Column1.62", "Column1.63", "Column1.64", "Column1.65", "Column1.66", "Column1.67", "Column1.68", "Column1.69", "Column1.70", "Column1.71", "Column1.72", "Column1.73", "Column1.74", "Column1.75", "Column1.76", "Column1.77", "Column1.78", "Column1.79", "Column1.80", "Column1.81", "Column1.82", "Column1.83", "Column1.84", "Column1.85", "Column1.86", "Column1.87", "Column1.88", "Column1.89", "Column1.90", "Column1.91", "Column1.92", "Column1.93", "Column1.94", "Column1.95", "Column1.96", "Column1.97", "Column1.98", "Column1.99", "Column1.100"}),
    #"Promoted Headers" = Table.PromoteHeaders(#"Split Column by Delimiter", [PromoteAllScalars=true]),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Promoted Headers", {"TijdVanOnderzoek", "OnderzoekVerichtOp", "AantalVisites", "SerieNummer", "Evaluatie", "AppointmentId", "Id"}, "Attribute", "Value"),
    #"Changed Type" = Table.TransformColumnTypes(#"Unpivoted Other Columns",{{"Value", type number}})
in
    #"Changed Type"

And then if you want a radar chart you may need to add a dynamic percentage calculation to each of your categories in case you want the radar chart axes to be of the same size.

[DionTN]

How did you use the settings? When I add values to the graph they will be visible on every label.

[lbendlin]

I am using a different visual. See attached.

[lbendlin]

The xViz Radar/Polar chart seems to have a few more features