Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Displaying series in a Line Chart/Adding series to a Line Chart (Filtering a Line Chart)



I've got a ListBox control (ListBoxCategory) and a drop-down control (DropdownEmployee). I would like my Line Cart to display information based on the employee you select in the drop-down list, and the categories you select in the list box.


  • The ListBoxCategory uses a data source (CategoryTable) which contains a 'CategoryID' and 'Category' column.

CategoryTable2.jpgData source: CategoryTable

The ListBoxCategory's Items is set to 'CategoryTable', and the Value is set to 'Category' - it displays 'Lunch', 'Meetings', 'Work', 'Travel', and 'Breaks' (the values in the Category column)



  • The DropdownEmployee uses a data source (EmployeeTable) which contains an 'EmployeeID' and 'Employee' column - it displays the names of the employees in the Employee column.

EmployeeTable.jpgData source: EmployeeTable

The DropdownEmployee's Items is set to 'EmployeeTable', and the Value is set to 'Employee'. 


The line chart's data source (EmployeeDetails) contains a 'Category', 'HoursSpent', 'Employee', and 'MonthYear' column. The MonthYear column contains dates formatted as text:


EmployeeDetails.jpgData source: EmployeeDetails

The line chart should display data from the 'HoursSpent' column that corresponds to the selected employee (DropdownEmployee) and the selected category(s) (ListBoxCategory). For example, if you select 'Lunch' and 'Travel' in the ListBoxCategory, it should display the corresponding 'HoursSpent' value (Y-axis) and the MonthYear (X-axis) so that you can see one line that shows which months the HoursSpent for Lunch and another line that shows the HoursSpent for Travel.


Right now I have it set to: 



but this is not working.


Please help.


Level 10

Re: Displaying series in a Line Chart/Adding series to a Line Chart (Filtering a Line Chart)

Adding @FilipK to assist with this question 🙂 @TopShelf-MSFT

Helpful resources


New Badges

Check it out!


Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,866)