Skip to main content

Power BI

Needs Votes

Single click to filter, double click to drill down

Vote (125) 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

3f94a031 53f0-4b07-8641-5c65734aba80 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

d2fd8916 a689-4cf0-abc9-8cd5232769cd 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

fe61ec27 809f-4207-b3e9-834f00550675 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

ac643e7c e800-ea11-a811-000d3a4f1ebb 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

f31870bd d3bd-4b46-8380-52077f1f980b 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

611bbc8f b47a-4c91-856b-633caa4f8617 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

ca3b38e5 8bd3-4125-b13d-228d698593fa 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

759303e1 ab53-4a15-861b-bc8712df6a65 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