Measure table to create radar chart

[Anonymous]

Hi,

I'm looking into ranking a list of stores based on several KPIs using measures. The data comes from three different tables, one for revenue, one for worked hours and one for number og sold products. I have created three measures that returns the %-growth for a selected time period (week/year) compared to the same weeks previous year. The time dimension is controlled with a "between"-slicer using a separate calendar table. 

I want to create a radar / spider chart, where the rank of my selected store evaluated for each measure is presented relative to the other stores for each measure. I.e. if my selected store scrore as number 5 in terms of revenue growth, number 9 in worked houers and 1 in growth for sold products, it should be displayed as the attached example:

How can I create such a visualization using my three measures? It should be able to filter on store names, store groups (high revenue, med. revenue, low revenue, all revenue groups), change the time period that is compared to the previous year (ie. wekk 1 of 2023 compared with week 1 of 2022, or week 1-4 2023 compared to week 1-4 2022 etc.)

[Anonymous]

Hi @Anonymous ,

You could try calculate table using dax. SUMMARIZE() and UNION() more suitable for you.  then use Radar Chart , KPIs as category, Planned and Actual as Y-axis. 

You can use the RANKX()  function to create a measure to rank your stores.

You can refer to the similar posts that may be helpful to you:

Power BI Custom Visuals - Radar Chart (pragmaticworks.com)

Radar Chart - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.