cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
codebrane
Level 8

Programatically change Chart.Items and Chart.Series1

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
codebrane
Level 8

Re: Programatically change Chart.Items and Chart.Series1

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.

View solution in original post

1 REPLY 1
Highlighted
codebrane
Level 8

Re: Programatically change Chart.Items and Chart.Series1

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.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 327 members 6,139 guests
Please welcome our newest community members: