topic Re: PowerBI radar chart - Avoid writing one measure for each "line" displayed in the chart in DAX Commands and Tips

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

Username1848 — Tue, 25 Jun 2024 14:27:40 GMT

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.

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

mark_endicott — Tue, 25 Jun 2024 16:09:08 GMT

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/

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

mark_endicott — Thu, 27 Jun 2024 09:42:27 GMT

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

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

Username1848 — Thu, 27 Jun 2024 09:57:44 GMT

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