cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jmdatasci
Level: Power Up

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

Hello,  I am trying to generate a single screen with a drop down menu and a line chart.  When the user selects the value in the dropdown, I would like to have the line chart display the data in the series of that selection.  I can't seem to get the filtering correct or the table structure and I keep having issues.  For this I have created 3 tables.

 

Table 1- Raw Data

Table 2 - List of Series Names (Dropdown Options)

Table 3 - Transposed Data Removed additional rows  (Table 2 is top row transposed)

 

The way my data looks like:

 

Table 1 - 

 

          z1     z2      z3     x1     x2      x3     x4

ser1   i11    i21    i31    y11   y12   y13   y14

ser2  ...

ser3

ser4

 

table 2

 

ser1

ser2

ser3

ser4

 

Now with table 3 has each series with Row A as the series name, I dropped the rows that are not relevant for the chart (z1, z2, ..., )  so now it looks like this:

 

xs    ser1   ser2    ser3    ser4  

x1     y11   y21     y31    y41  

x2     y12    y22    y32    y42 

x3     y13    y23    y33    y43

x4     y14    y24    y34    y44  

 

What I am trying to make now is a dropdown that uses the values in Table2, and chooses which series to plot on the chart using the data in table 3 (or table 1 if that is possible but I couldn't get it to do anything with the uselss text fields in it).   In the doucmentation it said I need to use transposed series which left me where I am.  

 

The logic I have already tried to add is for the filter of the table but doesn't work when transposed.  

 

Dropdown:

Data > Items: Table2

    Value > Series

OnChange > Set(series, Dropdown1.Selected.Series)

 

Chart:

Data > Items:  Filter(Table3, Dropdown1.Selected.Series = series

Labels = xs

Series1 dropdown can't be modified except to manually select a different series, cannot add logic here.

 

 

Other things I have tried but couldn't figure out:  

OnChange - Set(CompositeLineChart1.LineChart1.Series1, Dropdown1.Selected.Series)

 

 

I was able to successfully get the dropdown to work for up to 9 series' by using the function:

 

Filter(Table3,Dropdown1.Selected.Series exactin Table2.'Series') the problem is this only works for the first 9 series that are populated into my chart since the series fields are protected.  

  

Does anyone know the basics of creating a PivotChart in Powerapps?

1 REPLY 1
Lisabel0
Level 8

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

Can you use the third table directly from the data source side?

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 220 members 4,757 guests
Please welcome our newest community members: