Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am currently building a matrix that has 2 row values and one column. I have formatted this matrix to colour based on whether a role is over/under/within capacity for that month. The current table this is coming from is setup like this:
Role | Month Year | Time Type | Hours |
Consultant | January 2024 | Project | 30 |
Consultant | January 2024 | Capacity | 40 |
Consultant | January 2024 | Request | 15 |
The matrix currently looks like this:
Where the totals (e.g., developer) are correct but the project/request level and grand total on the bottom is incorrect. The values in the matrix are summing hours where time type = Request or Project, and is compared against a measure for Capacity where Time type = Capacity.
Is there anything I'm doing incorrectly? I thought it might be because the capacity measure isn't in the matrix, but then the totals shouldn't be correct either?
Many thanks
Solved! Go to Solution.
In case anyone is curious or has the same issue, I found that because my capacity was also marked within the time type column, it was filtering it out in the matrix (as I only added project and request types together). This measure solved the issue for me:
In case anyone is curious or has the same issue, I found that because my capacity was also marked within the time type column, it was filtering it out in the matrix (as I only added project and request types together). This measure solved the issue for me:
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |