All Content
Timespan
explore our new search
​
Impressive Excel Dashboards with Two-Level Slicer Trick
Excel
Feb 9, 2023 9:00 PM

Impressive Excel Dashboards with Two-Level Slicer Trick

by HubSite 365 about Chandoo

Pro UserExcel

Imagine you have a dashboard with a slicer. But the slicer has 300 options on it.

Imagine you have a dashboard with a slicer. But the slicer has 300 options on it. We can all agree that it will be impossible to slice such a thing. But do you know that we can easily introduce a second slicer (on something like Product Category) to filter down the products first? Watch this video to learn the trick.

PS: There is a bonus trick in the video too. Watch until the end for it.

In this Video

0:00 - The Two-Level Slicer - Quick Demo

0:37 - How to create two-level slicers?

4:06 - What if you do not have categories? (Bonus trick🤩)

📂 DOWNLOAD THE SAMPLE FILE:

=============================

Download the sample file to practice this concept: https://chandoo.org/wp/wp-content/upl...

The Two-Level Slicer Trick i

The Two-Level Slicer Trick is a quick and easy way to create an impressive Excel dashboard. This trick allows you to quickly filter data from two different sources or categories in the same worksheet. With this trick, you can easily compare data from one source against another, making it easier for users to spot patterns and trends within their data.

The trick also makes it easier for users to identify outliers that may be influencing results without having to manually search through multiple worksheets or databases. Furthermore, this technique provides an efficient way of creating interactive Excel dashboards which can help visualize complex relationships between data sets more clearly than traditional charts and graphs.

YouTube · Chandoo · 2 hours ago

Aug 18, 2015 — 2. Retrieve data with LOOKUP formulas. Mastering lookup formulas is a key technique for many data projects in Google Sheets (and Excel). It's at ...

In Excel, an interactive dashboard is essentially a slice of visualization that allows your data to tell a story. reporting, performance dashboard ...

6 steps