Select Page

Excel Video 493 Drilling Up and Down in a Power View Matrix

Feb 1, 2016Business Intelligence, Excel 2013

Drilling Up and Down in a Power View Matrix is one of the advantages of a Power View Matrix compared to a Power View Table, and that’s the topic of Excel Video 493. It’s easy to add multiple fields to the rows and columns areas in a Power View Matrix, but the visualization gets very crowded very fast. Watch how to turn on the drill down feature to collapse the data and make it easier to focus on what’s important. It’s also easy to drill back up to see higher levels in your data hierarchy.

Now that we’re in February 2016, we’re a month away from the 500th Excel Video. To celebrate, I’m giving away a free CMS referral data analysis. Watch the video for more information.