Forum Discussion

DDalmas's avatar
DDalmas
Frequent Visitor
5 years ago

Data Model for radar/polar/donut chart

File: https://easyupload.io/wg28x6

Hello everyone, 

I'd like some help with this case. There is one test for each employee for this company, and each oh them belongs to one unit. This client have requested for a radar chart to compare employees or/and units by each atribute of this test. So, I have to create a visual where the client will be able to compare anything he wants. It must have a data segmentation by Employee and Unit. 

Examples: 
1) Avarage Score by Unit.

 

2) Compare Employee's Score with Company's Avarage. 


I've tryied several community visuals but nothing really works like excel.  Any tips how to solve it? 

Thanks in advance. 😁




Need Help
Tips and Tricks

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    Have you tried one of the Radar charts in AppSource (click ellipsis under visuals and choose Get More Visuals)?

    Pat

     

    • DDalmas's avatar
      DDalmas
      Frequent Visitor
      5 years ago

      Hi mahoneypat 

      Yes, I've tried.  The problemwith those charts is that PowerBi works with column values, so for example the units goes to the radar, not the atributes/scores from the test. 

      Also, I've tried toconvert the table lines into columns, but there is no way to filter them after this. 

      Problem 1)  Units into the radar poles. 


      Problem 2) No way to filter, units for example.