Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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:
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
77 | |
72 | |
56 | |
40 | |
35 |
User | Count |
---|---|
71 | |
65 | |
57 | |
49 | |
47 |