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

Report
All responses (
Answers (