Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
The Drilldown API allows you to create a visual that can trigger a drilldown operation on its own, without user interaction.
The API enables the visual to show next level, expand to next level, or drill up based on the parameters passed to the API. For more information about drilling down, see Drill down support.
Note
The Drilldown API is available from API version 4.7.0 To find out which version you’re using, check the apiVersion
in the pbiviz.json file.
Add the following to the capabilities.json file:
"drilldown": {
"roles": ["Rows", "Columns"]
}
The following example shows how the visual call a drilldown operation.
public update(options: VisualUpdateOptions) {
if ((options.dataViews[0].metadata.dataRoles.drillableRoles['Columns']).indexOf(powerbi.DrillType.Down) >= 0) {
let args: powerbi.DrillDownArgs = {
roleName: "Columns",
drillType: powerbi.DrillType.Down
};
this.host.drill(args);
}
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Module
Use visuals in Power BI - Training
Create and customize visuals to present data in compelling and insightful ways.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
Documentation
Subselection API in Power BI Visuals - Power BI
The article describes how to use Power BI Visuals subselectionAPI to allow users to format visuals easily.
The dynamic drill-down API in Power BI visuals - Power BI
This article explains how to create a Power BI custom visual that allows the user to enable or disable drill-down support.
Format objects directly API in Power BI Visuals - Power BI
The article describes how to use Power BI Visuals On-object formatting API to allow users to format visuals easily.