Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
CNovak
New Member

Data Formatting

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:

Actuals % = format(calculate (sum('Summary'[Hours])) / calculate( sum('Summary'[Hours]) , all ('Summary'[Grouping])) , "00.0%")
 
Is there some formatting option I'm missing that would remove this issue?
 

Capture.JPG

 

Any help would be appreciated!

 

Thanks

 

Chris

 

1 ACCEPTED SOLUTION
CNovak
New Member

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.

 

 

Filter.JPG

View solution in original post

1 REPLY 1
CNovak
New Member

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.

 

 

Filter.JPG

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.