Is there a way to have your chart drilldown start on a custom date slicer value?

[quinnjohnson]

I have a report with a slicer that allows the user to select a relative date (last 3 calendar months, etc). From there, two clustered column charts will populate with data showing the current timeframe selected as well as the previous year of the time frame selected. I am wondering if there is a way for those charts to automatically drill down or up to the selected date value? So if the charts are currently showing just the current year and the user changes it to "last 10 days", the chart will then automatically drill down to days. Is that possible? Obviously they can just click drill down but you can never under/overestimate the ability of others. 

Thanks!

[parry2k · Accepted solution]

@quinnjohnson unfortunately it is not possible, it will not auto drill down.

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[quinnjohnson]

Darn. Thanks for letting me know!