KPI in radar chart

[ThomasWeppler]

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.

[v-robertq-msft · Accepted solution]

Hi, @ThomasWeppler 

According to your description, I can’t clearly understand your requirement. I think you can try the Switch() function in DAX to return different values for multiple possibilities.

If you can’t figure it out by yourself, you can post some test data so that we can help you in advance.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.