I've been trying to figure this out, but I cant seem to find the solution anywhere, could be that it just cant be done.
What Im trying to do is create a Pie Chart in my PowerApp that will change the Series depending on the selection on a Galery.
So I'm thinkling it should be something like this:
Of course filter wont work because the values of the series are the columns themselves in the excel file, so im trying to find a way to have the series (Excel Column) be defined by whatever is selected in a Galery,Dropdown, etc...
Thank you for your assistance
Sorry but your description is quite unclear.
What is the data source that you want to use in the Pie Chart? You meaned Series and I saw in you screenshot there is one Dropdown control with Series field but what is the data source of series? And the excel table you posted in your screenshot, is it the data you want to show in your Pie Chart?
If there are 2 data sources involved in this scenario, please share both with screenshots. Also what is the data of Series dropdown?