Power Platform Community Forum Thread Details

I have the following 2 SharePoint lists:-

1) Main Category. with those fields:- Title + ID

2) Process. with those fields:- Title, Weight, MainCategoryID

where the Process table, stores the MainCategoryID as a number field to link the Process list with the Main Category list.

Now i created a Canvas app inside Power Apps. and i need to build 2 Pie Charts, as follow:-

1) First chart to show/group the Process items based on their Sum of their weight per Main Category Title

so the Pie chart will show the following:-

- Weight of all items which are under MainCatoegy-1 >> 20%

- Weight of all items which are under MainCatoegy-2>> 25%

- and so on

2) Second Pie Chart to show/group the Process items based on their count per Main Category Title

is this possible? and can i show the MainCategory Title inside the Pie chart instead of its ID?

Thanks

Categories:

Build a Pie Chart for our Items sharepoint list