Drill Downs Keep Turning Themselves Off

[thegeo]

Hi,

I have several line charts where the X axis is a date and I want the user to be able to drill down. I keep turning on drill down buttons, but for some reason they keep turning themselves off. I'm not sure if it's opening and closing the pbix file that does it. Or maybe it's when the data updates. Again, not sure.

Is this a bug?

Thanks,

The Geo

[BorisMa]

I have managed to work around this issue by turning "keep all filters" to off.

In my case I had a stacked column chart that represents the hour of the day and the shifts in this hour. I wanted to be able to drill through to see all of the shifts in a a specific hour and not just one. Since there is no option to drillthrough a specific hour (in online report like you can do in power bi desktop) I used the keep all filters off.

By turning the keep all filters off it didn't keep the shift filter and showed me the shifts per hour

If there are filters that you do want to keep you can create slicers that are synced between the different pages thus maintaining partial filtering if needed

Hope it gave you ideas 🙂

[v-jiascu-msft · Accepted solution]

Hi @thegeo,

I think this is a functional design. When you want to use it, then open it. According to my test, it will be turned off when the file is closed. Let's try to think about this scenario. Someone new to Power BI would say: I click the visual (accidentally maybe), it jumps to somewhere else. I don't know why. I just try to select some points.

So this could be a good design. You want to use it, open it.

Best Regards!

Dale

[thegeo]

Thanks for the answer. Unfortunately, it's not a very satisfactory one. This project is for clients, and they will have to keep turning on drilldowns every time they access a report. 

I hope Microsoft will fix this. If I have turned on a drilldown, it's because I want it on.

[v-jiascu-msft]

Hi @thegeo,

I would suggest you vote this idea: drill-mode-by-default. Many people have voted. Maybe this feature will come up soon.

Best Regards!

Dale

[thegeo]

Thanks! Will do.