cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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

Hi,

 

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.

Data source: CategoryTableData 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.

Data source: EmployeeTableData 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:

 

Data source: EmployeeDetailsData 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: 

Filter(EmployeeDetails,Employee=DropdownEmployee.Selected.Employee,CategoryValue=ListBoxCategory.SelectedItems.Category)

 

but this is not working.

 

Please help.

 

1 REPLY 1
Highlighted
Anonymous
Not applicable

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

Adding @FilipK to assist with this question 🙂 @Anonymous

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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