Forum Discussion
Helper IITranspose table for radar graph
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.
Super UserRead 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
Helper IIUnfortunately 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.
- lbendlin
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.