How to publish a report with drill mode automatically on

[NickNIcolaides]

I have created a report, but in order for the charts to behave and interact the way the user has requested, "Drill Mode" needs to be selected.

Is there a way to publish this report, so that "drill mode" is automatically enabled each time a user goes to the report?

[v-sshirivolu]

Hi @NickNIcolaides ,
Thanks for reaching out to the Microsoft fabric community forum.

Create a Hierarchy
In Fields pane, right-click Status Group - New hierarchy
Name it: Status Hierarchy
Drag Sub-Stage into the hierarchy (beneath Status Group)
Create a Visual
Insert a Stacked Column Chart
Add Status Hierarchy to Axis
Add Count to Values

Test Drill-like Behavior
Use built-in buttons from the visual toolbar:
"Go to next level" (double down arrow)
"Expand all levels" (forked arrow)

Add Drillthrough Page
Add a new page: “Drill Details”
Drag Status Group into the Drillthrough field well (on the right)
Add a Table visual with: Sub-Stage, Count, Duration
Go back to the main report page
Right-click on any Status Group bar - Drillthrough - Drill Details

Please find the attached .pbix file for your reference

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Sreeteja.
Community Support Team 

[mark_endicott]

@NickNIcolaides - I'm afraid this is not a state that Power BI remembers.

However, if you enable the Modern Visual Tooltips: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-visual-tooltips?tabs=desktop-new you will find that the drill down functionality is much more intuitive than having to ask users to click this button on each chart every time they access a page. 

If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!