Forum Discussion

HansBroecker's avatar
HansBroecker
New Member
11 months ago
Solved

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 Reporti...
Need Help
  • MFelix's avatar
    MFelix
    11 months ago

    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's avatar
ThomasWeppler
Icon for Impactful Individual rankImpactful Individual
11 months ago

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