Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Morning everyone,
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
Natalie
xXx
Hi @Anonymous,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |