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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
Thought I've taken a starter course in Power BI, I'm mostly self taught and dont have many if any resources to turn to for help with this. This is likely an incredibly basic question, but please bear with me! I've had a look online for an answer, but I'm drawing a blank at the moment.
I'm looking to build up some tables that display how much time is spent on a given grouped activity and what proportion of the total time that represents (the below example filtered for admin tasks). I dont know if it's how I've constructed the measure, but I'm struggling with the additional rows that appear (marked in yellow) when I add the "Actuals %" measure into the table. I imagine it's the table looking to present all possible grades that exist for each worker option, but I can't understand why it's looking to do that.
For reference, I'd created the measure as:
Any help would be appreciated!
Thanks
Chris
Solved! Go to Solution.
Finally figured out what I've been missing and it is embarassingly simple.
Sharing here on the chance that someone else is as blind as I am and overlooks the Filters section. Essentially, it was right there and I just needed to select for the column to show entries where there are non blanks.
Finally figured out what I've been missing and it is embarassingly simple.
Sharing here on the chance that someone else is as blind as I am and overlooks the Filters section. Essentially, it was right there and I just needed to select for the column to show entries where there are non blanks.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.