Data Model for radar/polar/donut chart

[DDalmas]

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

[mahoneypat]

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

Pat

[DDalmas]

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.