Pie Chart to show number of same item

(0) Share

Report

Posted on by vikna

175

I have Sharepoint called JML 3.0 and one column is called "Location".

This column has for location called, "Menara Shell", Lutong, "PS" and "LSB".

This column will have multiple number of the same location based on the input by user.

I need to do a pie chart in Powerapps, whereby the Legends will be these 4 locations and the item in pie chart should show number of times "Menara Shell" or the other locations is in the Sharepoint.

If Menara Shell has 8 rows, then it should show the number 8 in the chart.

Please advise as I'm not sure how to do this.

Thank you in advance!

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @vikna ，

Please try:

AddColumns(GroupBy('JML 3.0',"Location","NewGroup"),"CountLocation",CountRows(NewGroup))

Best Regards,
Bof
vikna 175 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks for the advise @v-bofeng-msft ..

I've managed to get it to work as per your advice.
However, in the pie chart, can I make it to show the number instead of the location name?
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @vikna ,

You could set the pie chart's label property to 'CountLocation'

Best Regards,

Bof
vikna 175 on at

Like
a
(0)

Report
Copy link

Link copied!

I've tried doing this for the first solution and it works too...however, the legends also turns to the numbers.

If there is no other way, then I think I can just add new text item on top of it to hide the legends.
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @vikna ,

Please try:

ShowColumns(AddColumns(GroupBy('JML 3.0',"Location","NewGroup"),"CountLocation",CountRows(NewGroup),"NewTilte",Location&" "&CountRows(NewGroup)),"NewTilte","CountLocation")

Best Regards,

Bof
hayleymaree 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello - how would this change if Location was a choice field?