PowerBI radar chart - Avoid writing one measure for each "line" displayed in the chart

[Username1848]

Hello all,

I have a question regarding the radar chart in PowerBI. I want to re-create a radar chart in PowerBI like I have one in Excel/PowerPoint. Please see the first picture for reference what I want to do. My data is structured as shown on the second picture. In the PowerBI radar chart I would have to create one measure for each customer that I want to display in the chart. I have like a hundred customers in my data, so that’s not very practicable for me.

Is there a work around writing one measure for each customer and still have all customers visible on the radar chart? It is meant to be filtered, so there will only a few be visible at the same time.

Thank you in advance!

This is what I want to re create in PowerBI

This is how my data is looking, but with like a 100 customers. I want to avoid writing one measure for each one.

[mark_endicott]

@Username1848 - Did this work? Please mark it as the solution if so!

[Username1848]

Not the solution I was hoping for, but I guess there is no option to solve it otherwise.. 

[mark_endicott · Accepted solution]

@Username1848 - You can do this with one measure if you use the XViz Radar/Polar Chart, however you will need to buy a licence for this visual after one month of use. There is more info here: https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001442?tab=overview

Alternatively, I'm sure you could use the Deneb visual to create this yourself, but you would need to learn Vega or Vega Lite coding languages in order to take this option. There's more info on that here: https://deneb-viz.github.io/