Hi @PPars2025 ,
To address your challenge of visualizing employee performance scores on a line chart in Power BI, while also incorporating quarterly performance and employee names, it’s important to make strategic use of Power BI’s features. The Y-axis in a line chart is designed for numerical or categorical data, so directly placing employee names there isn’t possible. However, you can create a clear and informative visualization by leveraging legends, tooltips, and grouping.
Start by assigning the Date field to the X-axis and the average scoring measure to the Y-axis. To differentiate performance scores for each employee, drag the Employee Name field into the Legend section of the line chart. This will generate separate lines for each employee, using colors in the legend to distinguish them. Enabling data labels in the Format pane ensures that scores are displayed directly on the chart. Customizing the tooltips to include employee names, scores, and other relevant details will further enhance the chart’s clarity.
If you need to show performance aggregated by quarter, you can group dates into quarters using a calculated column in DAX, such as:
Quarter = "Q" & ROUNDUP(MONTH('Employee Table'[Date]) / 3, 0)
This formula generates a new column that groups dates into "Q1," "Q2," etc. You can then use this quarter field on the X-axis of your line chart to aggregate and display performance scores by quarter. The Employee Name field can still be included in the Legend to create lines representing each employee's performance across quarters.
For a more customized approach where employee names are effectively represented on the Y-axis, you can assign a numeric rank to each employee. This can be done with the following DAX formula:
Employee Rank = RANKX(ALL('Employee Table'), 'Employee Table'[Employee Name], , ASC)
You can then assign this Employee Rank column to the Y-axis of the line chart, with the Date or Quarter field on the X-axis. The average scoring measure remains as the values, and employee names can be included in the tooltip to maintain clarity. Formatting the chart title or legend to explain the relationship between the ranks and employee names ensures the visualization is intuitive.
In reports with multiple tabs, such as those organized by quarters or supervisors, slicers can help dynamically filter the data across all tabs. Synchronizing slicers ensures consistency, allowing users to seamlessly navigate through the report. Bookmarks and buttons can also improve navigation and create a polished experience. Given that the dataset includes 27 employees, it’s important to avoid overcrowding the chart. Breaking down data by supervisor or department, or using filters to display fewer employees at a time, can significantly improve readability.
These approaches ensure your report captures employee performance effectively across both time and organizational dimensions, while maintaining clarity and usability.
Best regards,
