Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi There
I urgently need help with this
I am trying to figure out how to show how much each person is being utilized every month out of their total capacity in a stacked graph.
I have appended query showing
Yellow - how many days each week a person is booked on a project (allocated)
Blue - How many days they are available that week (capacity)
I think I need to add a measure, but not sure what calculation will work.
No 1 is my primary visual showing all allocated, but when I filter this by date my 2nd visual aligns to allocated and removes the capacity. Ideally, i would like this 2nd visual as a stacked graph but haven't been able to make that work
https://drive.google.com/file/d/1WCf6YP8mE2BlSndGF92hrnZGQquKg6-1/view?usp=share_link
any help on this would be brilliant
Thank you
Thank you for your reply!!
Not sure what's going wrong., but it's not working correctly...
Updated file:
https://drive.google.com/file/d/1WCf6YP8mE2BlSndGF92hrnZGQquKg6-1/view?usp=share_link
@Fiona83 Seems like it should be something along the lines of:
Utilization % =
VAR __allocated = SUMX(FILTER('Table',[Source] = "allocation"),[Days])
VAR __capacity = SUMX(FILTER('Table',[Source] = "Capacity"),[Days])
VAR __Result = DIVIDE(__allocated, __allocated + __capacity,0)
RETURN
__Result
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
109 | |
98 | |
39 | |
30 |