I have a bar chart with a drill down.
When I drill into the drill down for each week banding, I see every week and the label of the drill down it belongs to.
I don't want to see every week, only the weeks that contain data.
I also don't want the axis to say "drill down due this week" I want it to show the day.
Is this possible and hw can I do that?
Many thanks for any help
According to your screenshot, you select Ageing, Ageing Order, WeekCommencing and resolveby fields as Axis level, when you click drill down, it will display the Ageing Order and value. When you continue to drill down, it will return the WeekCommencing and value and so on.
>>I also don't want the axis to say "drill down due this week" I want it to show the day
In your resource date, there is day level date? If it does, you'd better create a hierarchy week->days, you can revire more details here.
If this still does not resolve your problem, please share your sample data or .pbix file for further analysis.