Using Edit interations effectively

[jamiebarnes]

Hi,

I've created a dashboard in BI Desktop with the following charts:

Map

SmartfilterbySQLBI

Multi-Row Card

Gauge

Clustered colum chart.

-They all interact with each other as you would expect, you use the filter and it changes the rest of the charts.

However, I have a drill-down on the column chart, where you click a site and it drills down to the teams that are in that site. When I use the filter to select a site the cluster chart shows the site but you still have to click into it get the drill down.

Is there a way to automate the drill down if you use the filter to select a site?

Also, can the other charts update when you use the drill-down?

Thanks.

[jamiebarnes]

I thought as much, thanks for confirming.

[ankitpatira · Accepted solution]

@jamiebarnes unfortunately not i don't think there is a way currently to drill down based on filter selection without having any manual clicks.