cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Pinkybloo Regular Visitor
Regular Visitor

Chart labels not working as expected in drill down

Morning everyone,

 

I have a bar chart with a drill down.

 

Capture 2.PNGCapture.PNG

 

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.

 

Capture3.PNG

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

Natalie

xXx

1 REPLY 1
v-huizhn-msft Super Contributor
Super Contributor

Re: Chart labels not working as expected in drill down

Hi @Pinkybloo,

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.

Best Regards,
Angelia