Forum Discussion
Newbie: Problem with Visuals Radar Chart 3.1.3.0
Hi all,
I want to generate in the Desktop App a "Radar Chart" for using this i dowloaded the visuals "Radar Chart 3.1.3.0"
From excel i have the following datass imported:
| Title | Reporting Date | Category | Experience | Issue tracking and transparency | Riskmanagement | Escalationmanagement | Problemmanagement | Projectplanning | Sub-Supplier Management | Meeting management | Reachability | Flexibility | Working together |
| 47/25 | 17.11.2025 | Validation | 8 | 5 | 4 | 4 | 5 | 5 | 0 | 6 | 5 | 6 | 8 |
| 47/25 | 17.11.2025 | Projectmanagement | 3 | 4 | 3 | 4 | 5 | 4 | 2 | 6 | 6 | 5 | 4 |
| 47/25 | 17.11.2025 | Changemanagement | 4 | 3 | 2 | 6 | 4 | 4 | 4 | 5 | 6 | 4 | 3 |
| 46/25 | 10.11.2025 | Validation | 3 | 3 | 3 | 4 | 3 | 3 | 5 | 4 | 3 | 3 | 4 |
| 46/25 | 10.11.2025 | Projectmanagement | 5 | 3 | 7 | 8 | 8 | 9 | 6 | 3 | 5 | 6 | 7 |
The Radar must look like
I have "Validation" and the ratings must be displayed in the net
I have "Changemanagement" and the ratings must be displayed in the net (another chart)
I have "Projectmanagement" and the ratings must be displayed in the net (another chart)
To be honest
I am not able to bring it to work
The visual is always refering to the "categories" and the net is created with the contents from the category (but not with the column ratings)
Can please somebody help me?
Do i need to change the excel datas?...i am lost 😞
Hi HansBroecker ,
You need to unpivot your data based on the 3 columns you have:
Now you can use attribute in category and value in Y-Axis.
Then using a slicer you can have your data presented, or use the filter panel.
2 Replies
- ThomasWeppler
Impactful Individual
Hi Hans
I sometimes uses this visualisation myself. This is how I get it to work.
Step 1: I go to transform data -> Enter data
I type in the KPI I want to measure. The I press ok and close & apply.
I add the KPI to category
Then I write som simple Dax. Where each index in my KPI changes what calculation should be made.
Medarbejder KPIer =IF(SELECTEDVALUE('Medarbejder KPIer'[Index]) = 1, [Bruttomargin %],IF(SELECTEDVALUE('Medarbejder KPIer'[Index]) = 2, [Procent fakturerbar tid],IF(SELECTEDVALUE('Medarbejder KPIer'[Index]) = 3, [Fastholdelsesgrad],IF(SELECTEDVALUE('Medarbejder KPIer'[Index]) = 4, 1,IF(SELECTEDVALUE('Medarbejder KPIer'[Index]) = 5, [Tilstedeværelsesprocent],0)))))You will have to change all the calcualtions for your dataset to match your needs, but I hope this gets you in the right direction. 🙂 - MFelix
Super User
Hi HansBroecker ,
You need to unpivot your data based on the 3 columns you have:
Now you can use attribute in category and value in Y-Axis.
Then using a slicer you can have your data presented, or use the filter panel.
