cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nirman Frequent Visitor
Frequent Visitor

How to enable drill-down by default in Power BI?

Hi,

 

I have designed number of reports using Power BI desktop and uploaded them on PowerBI portal. My most of the reports have charts having drill-down feature. They work seamlessly and quite well. However, whenever a user opens any report through the PowerBI site, the drill-down is disabled by default, and user has to manually enable drill-down (by clicking on "Turn on drill-down" button). How can I publish my reports with drill-down enabled by default?

5 REPLIES 5
HarrisMalik Established Member
Established Member

Re: How to enable drill-down by default in Power BI?

@nirman This is not the right forum to ask this question. Please move your question to Power BI Service forum.

greggyb New Contributor
New Contributor

Re: How to enable drill-down by default in Power BI?

I can confirm the behavior. It is impossible to save the status of the 'enable drill down' button in a report. Regardless of the status at save time, the functionality is always toggled off in reports accessed later.

 

This is confirmed in both the Desktop and Service report interfaces.

 

Make sure you send feedback through the feedback menu item about this behavior. Also feel free to submit it as an idea on this community site. Those are the official bug report and feature request media. The forum, while viewed by Microsoft employees is not the official avenue for these items. It's great to post here to share findings with other users, though, so thank you.

ZLJ Regular Visitor
Regular Visitor

Re: How to enable drill-down by default in Power BI?

I know this is an old conversation, but came across it as i have the same frustration.  For anyone else needing this functioanlity, there is an Idea you can vote on here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11718786-drill-mode-by-default

 

Lorian Regular Visitor
Regular Visitor

Re: How to enable drill-down by default in Power BI?

2 years later and this is still not available 😞 shocking really. Has anyone figured out a work-around by any chance?

kishorekvn Frequent Visitor
Frequent Visitor

Re: How to enable drill-down by default in Power BI?

You may not find that option while creating dashboard in desktop application. But once you publish, you can navigate to your reports page(app.powerbi.com) and click on your visual, click on explore option, click drill down on. This will turn on drill down to that visualization. While presenting the deck or dashboard, no need of clicking arrow to activate drill down any more it will get activated by default.

 

@nirman 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors