how to visualize actual vs. target in radar chart, dependent on selection of slicer

[dogburalHK82]

Hi,

I would like to know how I visualize actual vs. target in radar chart. The actual value will be subject to selection of supplier (in slicer). 

I have 2 tables:

Table 1, containing supplier list vs. actual score of each category. 

Table 2, containing category against averaged actual score and target score. 

file uploaded here https://filebin.net/73cukzvprknxse4o

Basically,  while selecting supplier, i wish to show actual score and target in the radar chart

[Anonymous · Accepted solution]

Hi  @dogburalHK82 ,

Here are the steps you can follow：

1. Select [Cat-1],[ Cat-2],[ Cat-3] – Transfrom – Unpivot Columns.

2. Relationship between two tables Table1 [Attribute] -- Table2[Cat].

3. Result:

Best Regards,

Liu Yang

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