Answered

Pie Chart

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi guys, I am currently building an analytical feature within my app where I have a pie chart displaying the percentages of each item within the column as seen below.

However, I want to filter the pie chart above by only showing a specific item percentage and labelling the rest as "others", is there a way to do so or how can I edit my code below? Thanks in advance!

@WarrenBelz @RandyHayes @Drrickryp

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 @Anonymous ,

Please try:

AddColumns(
AddColumns(
GroupBy(
xxxx
),
),
"_percentage",
If(HiddenCategory="specific item",Text((_number/_total)*100,"0%"),"others")
)

Best Regards,

Bof
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi I did as you said, it worked at seen below. However, is there a way to merge all of the "others" section of the pie chart into 1 section? Thanks Again 🙂
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Please try:

AddColumns(
AddColumns(
GroupBy(
AddColumns(HiddenMasterGallery.AllItems,"NewLabel",If(HiddenCategory="specific item","specific item","Others")),
"NewLabel",
"_cat"
),
"_total",CountRows(HiddenMasterGallery.AllItems),
"_number",CountRows(_cat)
),
"_percentage",
If(NewLabel="specific item",Text((_number/_total)*100,"0%"),"others")
)

Best Regards,
Bof
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello again, the image below shows my current chart. Is it possible to change both the labels to percentages while having the legend as "Specific Item" & "Others"?
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ，

Please try:

AddColumns(
AddColumns(
GroupBy(
AddColumns(HiddenMasterGallery.AllItems,"NewLabel",If(HiddenCategory="specific item","specific item","Others")),
"NewLabel",
"_cat"
),
"_total",CountRows(HiddenMasterGallery.AllItems),
"_number",CountRows(_cat)
),
"_percentage",
Text((_number/_total)*100,"0%")
)

Best Regards,

Bof
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much! it works perfectly now:)))