skip to Main Content

Colin posted a good comment regarding my last football post:  not all columns/tables from the PowerPivot window are needed in the Field List, and it would be better if we could hide them.

Turns out that there IS such a dialog in CTP3 (I’m told it was also in CTP2, I just never used it):

   PowerPivot Hide Fields Dialog

This is showing me all fields from the DimLeadingVsTrailing table, and lets me hide fields – both from the PowerPivot window, and from the Pivot Field List.

OK, so I marked 3 of those 4 fields to be hidden from the Field List.  I also marked ALL of the fields from the DimHomeAway table, and here is what the Field List shows me now for those tables:

   PowerPivot Hidden Fields in Field List

OK, I only see Description from the one table, as expected.  Nice :)  And the DimHomeAway table is no longer expandable, because all of its fields are hidden.

One could argue, of course, that maybe DimHomeAway should not show up at all.  In fact, I’m gonna go make that argument right now 🙂

(Update:  we are trying to fix that before we release final bits.  Cross your fingers.)

Next Football Post

Rob Collie

One of the original engineering leaders behind Power BI and Power Pivot during his 14-year career at Microsoft, Rob Collie founded a consulting company in 2013 that is 100% devoted to “the new way forward” made possible by Power BI and its related technologies. Since 2013, PowerPivotPro has rapidly grown to become the leading firm in the industry, pioneering an agile, results-first methodology never before seen in the Business Intelligence space. A sought-after public speaker and author of the #1-selling Power BI book, Rob and his team would like to help you revolutionize your business and your career.

This Post Has 2 Comments
  1. Gee…I always seem to be the first person to respond to your latest blog posts. Must get tiring seeing the same “face” first thing, day-in, day-out (um…spouses and girlfriends excluded of course). Guilty as charged. My defense? Extreme enthusiasmitis.

    Anyway, the PowerPivot team never fails to surprise. Even at this late stage, you’re trying to get this bit right, even though you can righfully claim “by design” and move on.

    I’ve noticed that you can also select columns, right-click and select hide from the context menu – a useful option.

    1. Colin, faces that say nice things like that, can be seen as frequently as possible 🙂

      Seriously – you ask good, pointed questions. I like that. It’s also nice to see that you appreciate what we do. The PowerPivot team has been an excellent crew to work with over the past couple years. Truly some of the finest people I’ve met at MS.

      (To be clear, though – we’re trying to fix this for RTM, not CTP3.)

Leave a Comment or Question