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)
RE: Custom Viz access to the previous levels in a drill-down
The idea is about accessing the aggregation levels in the full drill-down (including previous levels, not only the current one). Unfortunately the Completed status is only referring to the possibility to drill down at all, which actually is not a solution to the idea. Without a solution to the actual requested idea the breakdown visual cannot be implemented in a stable way.
RE: Custom Viz access to the previous levels in a drill-down
'At first sight these seemed great news but... How can we access the data values of all previous drill-down levels? Can you provide a sample on how to do it, so that the "Breakdown trees" developer can update it... so that it can be integrated in the last version of PowerBi?
@fredrik, am I misunderstanding this issue? Do you have reached a veredict about this situation? or we can assume that the "Breakdown Trees" project is suspended?
If this is true are there any known alternatives or other directions to turn?
Thank you very much.
RE: Custom Viz access to the previous levels in a drill-down
This idea is all about accessing previous levels of a drill-down, not the drill-down functionality alone. The announcement link only shows how to enable drill-down in a custom visual. Can you provide a sample where you access the data values of all previous drill-down levels?
RE: Custom Viz access to the previous levels in a drill-down
This idea is all about accessing previous levels of a drill-down, not the drill-down functionality alone. The announcement link only shows how to enable drill-down in a custom visual. Can you provide a sample where you access the data values of all previous drill-down levels?
RE: Custom Viz access to the previous levels in a drill-down
This is great news, thanks Tzvi!
RE: Custom Viz access to the previous levels in a drill-down
This is great.
RE: Custom Viz access to the previous levels in a drill-down
This idea is all about accessing previous levels of a drill-down, not the drill-down functionality alone. The announcement link only shows how to enable drill-down in a custom visual. Can you provide a sample where you access the data values of all previous drill-down levels?
RE: Custom Viz access to the previous levels in a drill-down
Fantastic news! How we get the same drill down features which was available in 2015 Power BI API.
RE: Custom Viz access to the previous levels in a drill-down
Fantastic news!
RE: Custom Viz access to the previous levels in a drill-down
I'm glad to see that the status went to STARTED. Will the capability include the possibility to access previous drill-down levels (which this idea is all about)? From Tzvi Keisar's description, this is not clearly stated.