Productivity Visual from Excel in PowerBI
Hello everyone, I'm new to PowerBI. I've completed the DIAD course and watched a few videos on youtube. I'm fluent in Tableau but am working on transitioning my reporting into PowerBI. I've never built anything like this in either program and was curious if you could help me build this in PowerBI. I know I can use a matrix to display employee name, day, and values similar to the first 8 columns, but that's as far as I can go. Can I create a column in Power Query or something for the Objective column? Or should I create a reference table with employee name and objective to connect to and add the Objective column after values? Hours absent is a column that requires the manager to manually enter data. Can this be done in PowerBI? My thought was to offer a dropdown for values 0 - 40. In Tableau, I'd use a parameter but I'm not sure how to do this in PowerBI. Total Tasks is just the sum of daily values. Objective - Absence is the Objective minus (Hours Absent * Objective/40). The final column is the total tasks / objective - absence. Should I create a new measure or new column for these calculations? Lastly, is it possible to format the matrix in a similar fashion?
How to insert an additional header row in a table?
I'm setting up a report in PowerBI, trying to match the formatting of an existing report, but can't see how to insert text in or over my column headers: The header should look like: Name | ID | Date of Birth | Sex | | | dd | Mon | YYYY | | (where the column names are coloured) It's simple to do this in excel, but I can't see how to do it in PowerBI.
