In this video we show you how to dynamically switch dimensions using a parameter. I use this in a lot of dashboards where the audience is very wide, and some users might need to see things at one level of detail, while other users need to see things at a different level of detail. It's also really helpful for supporting other analysts as they can adjust the level of detail in your dashboard to match the business question they've been asked to answer.
You can download the workbook here:
https://tabsoft.co/2IoIKDA
The data is coming soon!