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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Matrix discipline vs working hours for employees





I want a matrix as follow:


                            Discipline A     Discipline B     Discipline C

Employee A                5 hours         2,5 hours            -

Employee B                1 hours           -                        3 hours


Total                           6 hours          2,5 hours            3 hours


I use a date slicer from the "hour logs" (see att.)

Is it also possible to use a "project days" slicer?


I have a matrix but by every disicpline comes the same: employee / working hours per discipline.


MatrixMatrixTables + relationsTables + relations

How can I fix this problem?

Microsoft Employee
Microsoft Employee

Hi @janwillem,

From your screenshot, you use the plansysteem_XXX_pr_project_days[Date] to create a slicer, right? In the Matrix, Name filed as row levels, the Discipline as column level, what's your value level? It's a measure or column? Could you please share more details for further analysis? 

Best Regards,

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors