skip to Main Content


Has THIS ever happened to you?  We’re not even out of the Aarons yet.

Simple and Slick

Yesterday I saw Ken Puls post a really simple and effective trick – intentionally introducing a BLANK() measure in your pivot just to add a spacer column or row – and my response was “simple and slick, I like it.”

Well today I’m in Michigan, conducting some PowerPivot training/consulting, and that makes today a great day for a similarly slick and simple trick.  Because hey, I’m not even here right now.  Who’s writing this post?? Smile

First Initial!

Over in the Customers table in the PowerPivot window, add a simple calc column:



No Slicer “Left” Behind!

Now add that field to the pivot as a second slicer:


And if you want, you can then go back and add a First Initial slicer too…


Lastly you may want to turn cross-filtering OFF for the First and Last Initial slicers – you really only need it “on” for the FullName slicer, and it will slow down your report to leave it enabled for the initiails.

See this post for details on cross filtering.

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 One Comment
  1. LOL! Yep, seen it and did much the same thing. Didn’t turn off the cross filtering though but… after reading your book and realizing the impact it has, I think I’m going to do that now. 🙂

Leave a Comment or Question