Measure table to create radar chart
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.)
