Problem with Pie-Chart

(0) Share

Report

Posted on by SteveH2

I am new to Building Power Apps and have a Problem to get the right Data for a pie charts.

I have a Sharepoint list with simple Data:

Date (Type Date), Number(Type number), Product (Type selection)

x.y.z 20 Product1

x.y.z 30 Product2

x.y.z 30 Product1

Now i want to make a Pie chart wich shows me the Sum of Numbers of each Product.

e.g. Product1 sum is 50.

I want do define a target value, e.g. 100

Then the pie chart should show me 50% reached (50 sales out of 100 reached)

Can anybody tell me what statement i have to use?

Regards

Steve

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @SteveH2,
Do you want to display the sum number of each project in pie chart and display the percentage of how many sales?
I did some test according to your requirements.

Following is my SP list.
1. Set the Items property of Gallery as:

AddColumns(GroupBy('List Test',"Name","NewGroup"),"ChartItems",Table({Value:100-Sum(NewGroup,number),label:"Gap"&"-"&100-Sum(NewGroup,number)&"%"},{Value:Sum(NewGroup,number),label:"Achieve"&"-"&Sum(NewGroup,number)&"%"}))

2. Set the Items property of Pie chart as:

ThisItem.ChartItems

Best Regards,
Kyrie

Was this reply helpful? Yes No
SteveH2 4 on at

Like (0)

Report
Copy link

Link copied!
Hi @v-mingkz-msft
Thanks for that solution, that is exactly what i am trying to do.

As said, i am very new to power apps and don't have experience. This is my first project.

I have tried to implement your solution, but I always get error messages.
Do i need a gallery to get this running?

I made a gallery, and put in your code with my List-Seetings as following:
AddColumns(GroupBy('Magazin-Sales',"Artikel","NewGroup"),"ChartItems",Table({Value:100-Sum(NewGroup,Anzahl),label:"Gap"&"-"&100-Sum(NewGroup,Anzahl)&"%"},{Value:Sum(NewGroup,Anzahl),label:"Achieve"&"-"&Sum(NewGroup,Anzahl)&"%"}))

This is my SP-List:

I get always an error here:

Function GroupBy has invalid Arguments.
"Artikel" -> Text, Number, boolean or date/time expected (something like this, translated from german)

I can't find out the problem with this function?

Best regards
Stephan

Was this reply helpful? Yes No
SteveH2 4 on at

Like (0)

Report
Copy link

Link copied!

I think i found the Problem now, first i had to use semicolon (;) instead of commas (,)
2nd Problem i have not a text-column in my SP-List. I have a dropdown selection.

With a Text-column, your exampel is working, with my dropdown selection not. How can i fix this?

And another question: Now the Pie-chart is inserted in a gallery. Is it possible to show the charts without a gallery? I want to show an overview on the Mainpage.

Was this reply helpful? Yes No
v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @SteveH2,
1. You can use AddColumns function to get the value of choice field and groupby.
AddColumns(GroupBy(AddColumns('List Test',"ProductName",Artikel.Value),"ProductName","NewGroup"),"ChartItems",Table({Value:100-Sum(NewGroup,number),label:"Gap"&"-"&100-Sum(NewGroup,number)&"%"},{Value:Sum(NewGroup,number),label:"Achieve"&"-"&Sum(NewGroup,number)&"%"}))

2. The chart embedded in gallery display the achieve percentage of each artikel, so it is dynamic and cannot be move out.

Best Regards,
Kyrie

Was this reply helpful? Yes No