pie chart and choice column values

Like (0) Share

Report

Posted on 14 Apr 2024 11:44:09 by Tiley

I'm working on an app in power apps where I have a form which collects the users name "employee" and then a choice field, called "organization(s)", where the user can enter multiple choices, i.e. "Organization A", "Organization B". The form then submits the data into a dataverse table.

I'm struggling with making a pie chart in power apps based on the data submitted. I would want the chart to display the organizations based on the employees belonging to each organization so that one can see how big the organization are. The problem is that I think that because the choice column "organization(s)" has many possible values in it (on one row), I would have to split these values using ";" and then create a new table using i.e. a collection.

5psn516667d-0469-...

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-jefferni on 15 Apr 2024 at 08:49:35

Like (0)

Report
Re: pie chart and choice column values

Hi @Tiley ,

I have a list where includes a Choices column that allows multiple selections:

In my PowerApps App, I created a collection to ungroup all the items on the Choices column values, then group the ungrouped entries based on the 3 types of choice. In the pie chart, I'm able to show the proportion of the choices:

The formula to create the collection:

ClearCollect( col22, //collection name AddColumns( GroupBy( Ungroup( test2, //SP list "Tools" ), "Value", "Grouped" ), "Count", CountRows(Grouped) ) )

Best regards,

Was this reply helpful? Yes No