Hide the "many" side of Power Pivot relationships by default
When we link a dimension to our fact tables, we rarely want to use this field on our Pivot Tables. We should be using the field from the One (Dimension) side as this allows proper cross filtering. I see many users get confused by why their filtering is not working after linking tables, and it is invariably due to the fact that they've put a value into the Values area, then used another field from that same table in a row/column/filter/slicer or timeline.
Hiding the many side of a relationship would go a long way to stopping users from getting into trouble with this issue, and make the tool much more accessible to newer users.
I see no harm in making this change - it would just be a default and could always be un-hidden if that was truly needed - but I see a huge amount of benefit to newer modellers and pros alike.
Kenneth Barber commented
I totally agree!