Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi all,
I'm new to this forum and looking for some help please. I'm working with the free Power bi Desktop version for a while now and usually know my way around. However, I have only basic DAX knowledge and assume I might need some help with exactly that.
I have two time series graphs and would like to make use of the drill down function. The first displays total hours and works perfectly.
The second relates to the percentage in the table. The problem is, that I only seem to have the choice between "Sum" or "Average".
I do not want the percentage to summarize but to show up exactly as in my table in the background according to the level that it shows.
Increase rate = increase in hours/ attendance hours
Thank you for your help.
Sandra
@Need Help
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 32 | |
| 31 | |
| 18 | |
| 12 | |
| 11 |