Relating an Horizontal and vertical table to use radar chart

[mvelazquez]

Hello!

I'm somewhat new to PowerBI and I'm running into an issue when trying to use a radar chart.

So I have two tables with pokemon's information. What I'm trying to achieve is to relate the "Name column" from table one to the first row of table two. The reason I'm trying to do this is so I can use a radar chart and a slicer, so when a user clicks on any of the names from table one, the different values from table 2 will fill up my radar chart. Any help will definitely be appreciated. Thanks in advance!

[v-piga-msft · Accepted solution]

Hi @mvelazquez ,

If you want to create the relationship for the "Name column" from table one to the first row of table two. I'm afraid that you need to Unpivot the columns for the names for table one in Query Editor and then you could create the relationship between the two tables under Model view.

Here is the output.

Best Regads,

Cherry

[v-piga-msft · Accepted solution]

Hi @mvelazquez ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @mvelazquez ,

If you want to create the relationship for the "Name column" from table one to the first row of table two. I'm afraid that you need to Unpivot the columns for the names for table one in Query Editor and then you could create the relationship between the two tables under Model view.

Here is the output.

Best Regads,

Cherry