Answered

Pie chart from Sharepoint choice column

(0) Share

Report

Posted on 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?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (9)

Report
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

Was this reply helpful? Yes No
Binntore 12 on at

Like (0)

Report

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

Was this reply helpful? Yes No
cagmiterek 2 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
SunilPrakash 18 on at

Like (0)

Report

Is there any way to show percentages for the same text out of Hundred% ?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Clewsy 4 on at

Like (0)

Report

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

cheers

Was this reply helpful? Yes No
AmyF 235 on at

Like (0)

Report

I'd like to know that too. Did you ever find that solution?

Was this reply helpful? Yes No