Skip to main content

Power BI

Completed

Custom Viz access to the previous levels in a drill-down

Vote (2933) Share
Will Thompson's profile image

Will Thompson on 12 Oct 2016 03:43:38

The current version of Power BI visualsation framework does not support access to the previous levels in a drill-down. I.e. you only get access to the current level when rendering. That makes it very hard to develop visualizations such as pivot tables or breakdown trees.

This would let custom viz developers add thing like pivot tables and Breakdown Trees :)

[This idea was created as an offshoot of https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15844186-pivot-tables-and-breakdown-trees. Fredrik had initially asked for updates to the Custom Viz API, but many votes and comments were cast assuming the idea was just asking for the Power BI team to build Pivot Tables or Breakdown trees!]

Administrator on 08 Jun 2017 18:44:57

Hi, Drill-down for custom visuals is now supported in the framework, so any developer can update their custom visual code to add drill-down support (where applicable). Here is the announcement with the details: https://community.powerbi.com/t5/Custom-Visuals-Community-Blog/Visual-API-1-6-and-Drill-down-capability-available/ba-p/190457 Documentation is on GitHub: https://github.com/Microsoft/PowerBI-visuals/blob/master/Capabilities/Drilldown.md

Comments (112)
Will Thompson's profile image Profile Picture

af7ae428 e5bb-4733-ac24-3151629446e4 on 05 Jul 2020 22:36:46

RE: Custom Viz access to the previous levels in a drill-down

'@Lukasz Why not this was a part of Power BI when it was introduce in market must have feature in Power BI.

Will Thompson's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:36:43

RE: Custom Viz access to the previous levels in a drill-down

The only reason power BI is able to gain such a big BI market is because of the customs visuals one such visual is frank's breakdown tree so our Dashboard get an dependency visuals not only breakdown tree however to make more complex customs visuals. So its important to have this "Custom Viz access to the previous levels in a drill-down" Enable soon!

Will Thompson's profile image Profile Picture

23ba1643 b428-4de0-a4ac-9431a492160f on 05 Jul 2020 22:36:26

RE: Custom Viz access to the previous levels in a drill-down

Dear Santa, this is all i want for Christmas! This would be a huge deal for us to be able to publish a pivoted rolled up financial statement and let our users drill in and out to see hidden detail behind each line item... oh i lied.. i also want a visual that lets me string Christmas lights around the boarder of my dashboards ;). Keep up the great work!!! You can do it!

Will Thompson's profile image Profile Picture

4e613e95 c3e6-4733-adcb-f51b7b6a5dc3 on 05 Jul 2020 22:35:55

RE: Custom Viz access to the previous levels in a drill-down

'@pedro totally agrees with you; Its one of the most important feature of Power to Build is own customs visuals.. If this is taken way then this may leads no options for developer to Build more complex customs visuals.. Must enable feature in API if custom visuals in power BI Build..

Will Thompson's profile image Profile Picture

1f7f2711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 22:35:24

RE: Custom Viz access to the previous levels in a drill-down

"To be transparent, so far our findings are that the infra to do this right for the long term is actually a very large intricate work item"

No pain, no gain :) Fact is that this is a fundamental gap in functionality that would enable 'proper' Power BI visuals.

Will Thompson's profile image Profile Picture

f5e3c0ae 6199-4f21-8cc6-be472890d95c on 05 Jul 2020 22:35:15

RE: Custom Viz access to the previous levels in a drill-down

Only the Idea without any Status from Power BI team.. hmmm

Will Thompson's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:35:05

RE: Custom Viz access to the previous levels in a drill-down

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17237591-between-option-on-dates-is-not-working-on-timeline - vote this

Will Thompson's profile image Profile Picture

3acba9bb 121a-41b4-a5a7-c094df176a61 on 05 Jul 2020 22:35:04

RE: Custom Viz access to the previous levels in a drill-down

'@Sohail 7026 Votes it should be started immediately

Will Thompson's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:34:56

RE: Custom Viz access to the previous levels in a drill-down

7002 votes should merit a comment - status update on our thinking around this from the PG

Will Thompson's profile image Profile Picture

ca8fa06b 26e4-4eeb-84ab-356ce7031b5e on 05 Jul 2020 22:34:51

RE: Custom Viz access to the previous levels in a drill-down

Update this idea Power BI team please