KPI in radar chart

This might be a difficult question to answer. It is definitely the most difficult question I have asked on this forum so far.

I want to add a radar chart to show diffrent KPIer from key employess.

I want to know how I can build the table that can support this chart.

I need 5 diffrent KPI that I can get data from other diffrent tables in my data set.

I also need to combine them with my users ids. So i can make a slicer that choose a specific user and than all the diffrent KPI will be shown for that user.

Here is my idea on how to do it.

Create a new table with the diffrent defines KPI. (With the "create new table function".) Add new coloums to this table with functions that I define based on the KPI I want to show.

But I am not sure how I should get User slicer into my table. Is the best solution to repeat the colums for each new key user and then add the 5 KPI for each user so we get a table like this?

User | KPI | value 

1      | 1    |  3

2      | 1    |  2

3      | 1    |  4

1      | 2    |  1

2      | 2    |  5

3      | 2    |  4

1      | 3    |  4

2      | 3    |  2

3      | 3    |  5

I could make something like this with a very, very, very long if formula, but it just seems like their most be a better way to do it.