Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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.

7 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Ken Puls shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base