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

sandeep Roy 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

Power BI Ideas Admin 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

Mark Walter 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

Power BI User 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

Pedro Innecco 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

Kanak 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

Power BI Ideas Admin 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

David 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

Power BI Ideas Admin 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

Power BI User 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