cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mvelazquez Frequent Visitor
Frequent Visitor

Relating an Horizontal and vertical table to use radar chart

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!

dos.PNGuno.PNG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Relating an Horizontal and vertical table to use radar chart

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.

relationship.PNG

Here is the output.

Capture.PNG

Best Regads,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Community Support Team
Community Support Team

Re: Relating an Horizontal and vertical table to use radar chart

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Relating an Horizontal and vertical table to use radar chart

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.

relationship.PNG

Here is the output.

Capture.PNG

Best Regads,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Community Support Team
Community Support Team

Re: Relating an Horizontal and vertical table to use radar chart

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)