Skip to main content

Power BI

Needs Votes

Single click to filter, double click to drill down

Vote (128) Share
Grant Hensel's profile image

Grant Hensel on 23 Jan 2016 03:00:03

Toggling between filter and drill down can be somewhat annoying once you know exactly what you want to do. What if you could single click a bar in a chart to filter the page for that value, or double click to drill to the next layer?

Comments (18)
Grant Hensel's profile image Profile Picture

Power BI User on 05 Jul 2020 22:30:42

RE: Single click to filter, double click to drill down

It will be much easier to use a function key to drill up and down dashboard segments without changing the mode between select and drill-down.
I think that could be applied for both desktop and web-based products.

Grant Hensel's profile image Profile Picture

Martin on 05 Jul 2020 22:29:32

RE: Single click to filter, double click to drill down

I absolutely agree. It would prevent management to use drill down feature with this setup eventually.
Double click would be much easier.

Grant Hensel's profile image Profile Picture

Javid on 05 Jul 2020 22:25:46

RE: Single click to filter, double click to drill down

I agreed with Emily. I was confused initially, that why drill down did not work.
Then I realize that I have to first activate in order to drill down.

Grant Hensel's profile image Profile Picture

sadf sdf on 05 Jul 2020 22:23:24

RE: Single click to filter, double click to drill down

Hello,
Thanks for the comment,
I am moving this to the ideas forum as this is a feature that could be added (not fixed)
Thanks
Chuck

Grant Hensel's profile image Profile Picture

Power BI User on 05 Jul 2020 22:21:18

RE: Single click to filter, double click to drill down

When I create a report in desktop with drilldown set in a visualisation, when I publish the report, I need to set it to drill down again each time. I should be able to set this as default behaviour, in the same way as I can set filtering behaviour.

Grant Hensel's profile image Profile Picture

Emily Schmalz on 05 Jul 2020 22:21:13

RE: Single click to filter, double click to drill down

Our users are accustomed to the Power View behavior in which a single click makes the data respond with details and a double click drills down. They do not like clicking the circle arrow button to enable, drilling down, and then having to click that button again to regain single click (detail) capability. It was way more intuitive in Power View.

Please eliminate the button and bring back this drill down behavior!

Grant Hensel's profile image Profile Picture

Grant Hensel on 05 Jul 2020 22:16:41

RE: Single click to filter, double click to drill down

The idea is that all current functionality would remain in place, but double clicking a bar in a chart (for example) would be a shortcut for:

Double click = 'enable drilldown' + 'click bar' + 'disable drilldown'

Grant Hensel's profile image Profile Picture

Erik Roukens on 05 Jul 2020 22:10:23

RE: Single click to filter, double click to drill down

It would work a lot better when a single click would show details and a double click would give the drill down function when clicking on bars in a graph