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.

Helpful resources


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

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


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round


Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 105 members 4,788 guests
Please welcome our newest community members: