Answered

Pie chart from Sharepoint choice column

Like (0) Share

Report

Posted on 6 Sep 2021 13:41:58 by Binntore

Hi all, I am a newbie when it comes to Power Apps and am struggeling with getting information from a choice column into a pie chart.

The choice column is called "Saksstatus" and has four different choices:

Registrert

Lukket

Tiltak planlagt

Tiltak utført

The list is called "Registreringer"

I need a pie chart with the total number of each row with the different choices.

I have played around with AddColumn and GroupBy functions to no avail.

Anyone able to help?

All responses (7)

Answers (1)

AmyF 235 on 29 Aug 2023 at 13:20:52

Like (0)

Report

Re: Pie chart from Sharepoint choice column

I'd like to know that too. Did you ever find that solution?
Clewsy 4 on 20 Apr 2023 at 12:59:25

Like (0)

Report

Re: Pie chart from Sharepoint choice column

I can get this to work fine, but would I modify to function to also show blank choices?

cheers
Community Power Pla... on 23 Aug 2022 at 19:06:31

Like (0)

Report

Re: Pie chart from Sharepoint choice column

Thanks!
I have an additional dilemma.

In my SharePoint list, I have a text column named "Country".
In my app I have a dropdown which delivers a variable called "SelectedCountry" using formula Set(SelectedCountry,Country_selection.Selected.Result)

I'm trying unsuccessfully to add a filter to the chart formula, so the chart only displays data where the column "Country" is equal to "SelectedCountry"

Any help is appreciated!
SunilPrakash 18 on 05 Jul 2022 at 17:19:05

Like (0)

Report

Re: Pie chart from Sharepoint choice column

Is there any way to show percentages for the same text out of Hundred% ?
cagmiterek 2 on 30 Mar 2022 at 00:09:16

Like (0)

Report

Re: Pie chart from Sharepoint choice column

Hi! I could use your help too.

How would I do this but with a list that has multiple words? I try to input MY list name with the words connected, and it's showing the error.

Thank you so much!
Binntore 12 on 07 Sep 2021 at 09:48:56

Like (0)

Report

Re: Pie chart from Sharepoint choice column

Thank you very much Wearsky, it worked like a charm 🙂
Verified answer

v-xiaochen-msft on 07 Sep 2021 at 01:35:30

Like (9)

Report
Re: Pie chart from Sharepoint choice column

Hi @Binntore ,

I did a demo for you.

1\ This is my list.

2\ Add a pie chart and set its Items property to:

ForAll(Choices(LIST165.Saksstatus) As A,{Number:CountIf(ForAll(LIST165,ThisRecord.Saksstatus.Value) As B,B.Value=A.Value),Value:A.Value})

3\ The result is as follows:

Best Regards,

Wearsky