cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

Highlighted
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

Highlighted
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 Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,424)