Newbie: Problem with Visuals Radar Chart 3.1.3.0

[HansBroecker]

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 😞

[MFelix · Accepted solution]

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.

[ThomasWeppler]

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. 🙂