Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Define the "Series" of a Pie Chart based on selection on a Gallery



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: 

Items: My_Source.My_Gallery.Selection


PieChart series.jpg


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

Community Support Team
Community Support Team

Re: Define the "Series" of a Pie Chart based on selection on a Gallery

Hi @HenrikV,


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?




Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.