Create a SharePoint Chart of Employee Counts by Date and Time
Question details
Display employee counts from a SharePoint list by date and time period on an intranet page.
- Product
- Microsoft SharePoint and Power BI
- Device & OS
- not provided
- Scenario
- A SharePoint list stores dates, employee details, work status, wing, and time periods in separate columns.
- Observed behavior
- The desired chart shows the number of employees for each date and time period on an intranet page.
Check that the list has a date column, a time-period column, and an employee identifier. Confirm that you can access the SharePoint site and have permission to publish a Power BI report and edit the intranet page.
Build the Date and Time Chart in Power BI
Use Power BI to group SharePoint list records by date and time period, then embed the report on a SharePoint page.
SharePoint Quick Chart cannot directly combine separate date and time columns for this chart. Power BI can use the columns as separate chart fields without combining them into a single value.
In Power BI Desktop, select Home > Get data > SharePoint Online list. Enter the SharePoint site URL, sign in, and select the list containing the employee records.
In Power Query, verify that the date column has a Date type and that the time-period and employee identifier columns contain the expected values. Select Close & Apply.
In Report view, add a clustered column chart. Put the date field on the X-axis, the time-period field in Legend, and the employee identifier in Values. Choose Count, or Distinct count if an employee can appear more than once in the same group.
Select Home > Publish and choose a Power BI workspace. Open the published report in the Power BI service and copy its report URL.
Edit the SharePoint page, add the Power BI web part, and paste the report URL. Publish the page and check that intended viewers can open the report.

Explore Employee Data in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility for an easier move from Office. Use WPS Spreadsheets to explore exported employee data and create charts; it does not replace SharePoint's embedded Power BI reporting.

Frequently Asked Questions
Can SharePoint Quick Chart combine separate date and time columns?
Quick Chart cannot directly combine those columns for this chart. Use Power BI to place the date on the X-axis and the time period in the chart legend.
How do I avoid counting the same employee twice?
In the Power BI chart's Values field, select Distinct count for a unique employee identifier. Use Count instead if each list row represents one employee occurrence you want to count.
Can everyone who can see the SharePoint page also see the Power BI chart?
Not automatically. Grant viewers access to the Power BI report and check that they have the required license or that the report is hosted in an eligible capacity.
Can I filter the chart by work status or wing?
Yes. In Power BI Desktop, add the work status or wing field to the Filters pane, or add a slicer so viewers can choose values in the report.




