Hello, First and foremost, thank you all for helping with my many Excel questions. I use VBA from time to time but I've never used Power Pivot (PP) before. In an effort to get accustomed to PP, I decided to create two simple tables, add them to the data model, create a pivot table from PP on them, and see what happens. The tables are: Color Animal Red Tiger Yellow Dolphin Blue Turtle Orange Snake and Color Number Red 1 Yellow 2 Blue 3 Orange 4 I simply tried to create a relationship on "Color" and then make a pivot table. Yet, when I attempt this, it doesn't create an expected 1-to-1 relationship. It puts all four numbers below each color? I'm not sure why this would be. Thank you.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Power Pivot Starting

Thread starter guexc1977
Start date Mar 31, 2019
Tags

color create pivot red yellow

guexc1977

New Member

Mar 31, 2019

Hello,

First and foremost, thank you all for helping with my many Excel questions. I use VBA from time to time but I've never used Power Pivot (PP) before. In an effort to get accustomed to PP, I decided to create two simple tables, add them to the data model, create a pivot table from PP on them, and see what happens.

The tables are:

Color	Animal
Red	Tiger
Yellow	Dolphin
Blue	Turtle
Orange	Snake

and

Color	Number
Red	1
Yellow	2
Blue	3
Orange	4

I simply tried to create a relationship on "Color" and then make a pivot table. Yet, when I attempt this, it doesn't create an expected 1-to-1 relationship. It puts all four numbers below each color? I'm not sure why this would be.

Thank you.