Twice recently I've used parameter actions to create a single column drill down and drill up to mimic a hierarchy.

1. HR Analytics KPI Dashboard (https://www.vizwiz.com/2020/11/hrkpi...)
2. Makeover Monday Week 46 (https://www.vizwiz.com/2020/11/advert...)

Many of the examples of drill down you've probably seen so far use either set actions or parameter actions to create an additional column. The drawback is that you end up with an extra column that only has values when you drill down.

In this example, I show you how to use only ONE column to mimic drill down / drill up functionality. In total, it requires 2 parameters, 4 calculate fields, and 2 parameter actions. I find this method much more intuitive to the user.

Let me know what you think or how you put it into practice. Enjoy!

Download the workbook on my blog https://www.vizwiz.com/2020/11/single...