Chart & Visualization Issues

Create a SharePoint Chart of Employee Counts by Date and Time

Emma BrownEmma Brown Nov 18, 2026 870 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Connect to the list

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.

2
Check the fields

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.

3
Create the chart

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.

4
Publish the report

Select Home > Publish and choose a Power BI workspace. Open the published report in the Power BI service and copy its report URL.

5
Add it to the intranet page

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.

Build the Date and Time Chart in Power BI
Access and licensing: Embedding a report does not automatically grant access. Viewers need permission to the report and the appropriate Power BI licensing or capacity.
Free Microsoft Office alternative

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.

Create spreadsheet charts to explore employee counts by date and time period.Open and edit Microsoft Excel formats, including XLSX.Work in a familiar spreadsheet interface with a lightweight Office alternative.
microsoft office alternative - wps office

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.