Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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 🙂
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
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.
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
Thanks! Will do.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |