While the addition of +/- to matrix row headers has made navigating matrices much easier, end users will often struggle with discoverability or navigating within the levels.
After watching a user Drill Down in a matrix and get lost when trying to return the matrix back to it’s original state, I started looking into how bookmarks can make for a cleaner user experience.
Luckily, this is not only easy to achieve, but there is an added benefit of being able to drill down on multiple visuals at the same time!
In this post, I will demonstrate how to navigate the levels of a matrix with buttons and bookmarks, as well as how to use this same concept to navigate the depth of multiple visuals at the same time while not impacting your filtering/slicers.
I will start by adding a button for each level that I want to drill down to, giving it a hover color change so it feels interactive. In this case, I have a Matrix with Year, Quarter, and Month as the Row Headers, so I will add a button for each.
I will then add a line shape under my buttons, one for each button, and hide my Quarter and Month underlines.
I will now create my Bookmark for the Year depth by selecting the Matrix, and all of my buttons and creating a bookmark that is for Selected Visuals.
It is very important to leave Data checked on, as this is what captures the depth of the matrix!
Now I will either Drill Down on my matrix, or Expand it depending on my desired user experience and capture another bookmark with the same settings.
Lastly, I will repeat for Month:
Now I will assign my buttons to their respective Bookmark Actions.
We can now control our depth with a single click, and navigate across levels skipping directly to the depth want to see.
This can be very useful when a report page has slicers or filters for the same dimensions we have for our depth, as the bookmark will not impact the slicers/filters on the page
You can take it even further by using this method to drill down multiple visuals at the same time
To do this, simply repeat the above steps, but with both visuals selected. We can now remain consistent across the page when we drill down, instead of drilling both visuals independently:
There are multiple benefits of implementing this kind of navigation for your end users:
- It is easier to discover the ability to drill down
- Users can skip directly to the level they want to view, limiting queries
- Less Clicks to move across levels
- If users drill down via right click > drill down, they can get lost and not realized where they need to go to drill back up. This gives an easy path back via button click
- Drilling multiple visuals at the same time while retaining your slicer/filter selection provides visual depth consistency and better usability
If you would like to Download the PBIX for this example, Click Here