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?
Line and Stacked Column Chart with Table not showing Negative Scale
Hi Team, I am using Line and Stacked Column Chart with Table I have negative values in table but in column chart scale is not showing negative Value. Also can it be possible to add Total as Column in Table . I tried to explore many options but unable to add Negative Scale in Column Chart and Total Column at the end of Table. If anybody knows about these options. Please do help me. Thanks & Regards Jamsher
