I have a bar chart with Items set to:
AddColumns(Filter('TestList', StudentId = Student.StudentId),"Test Name",TestName.Value)
and Series1 set to "Test Name" and all is working.
I need to change Chart.Items and Chart.Series1 on the fly, based on a droplist selection, so a new bar chart displays with the new data. Is this possible? Trying from a button doesn't work as there is no way to access Chart.Items or Chart.Series1 from code. Looks like I can only affect the look and feel of the chart rather than the data it displays.
thanks,
Alistair
Solved! Go to Solution.
Turns out I can do it by creating a collection in OnVisible and using that as the Chart.Items. In the button or drop down, I can then manipulate the collection and the chart updates automatically.
Turns out I can do it by creating a collection in OnVisible and using that as the Chart.Items. In the button or drop down, I can then manipulate the collection and the chart updates automatically.
User | Count |
---|---|
140 | |
133 | |
79 | |
75 | |
74 |
User | Count |
---|---|
210 | |
200 | |
71 | |
66 | |
55 |