Creating Pie Charts in Power Apps

(1) Share

Report

Posted on by PAJ

280

I have a gallery with distinct assignee names i.e XYZ and PQR

For the above sample data , i need 2 pie charts

1) Which will show 'Priority' piechart whenever a assignee i.e either (XYZ or PQR) is selected in Gallery

2) Which will show 'Type' piechart whenever a assignee i.e either (XYZ or PQR) is selected in Gallery

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Robu1 1,459 Super User 2025 Season 2 on at

Like (0)

Report
Hi @PAJ ,

Certainly! To create the two pie charts based on the assignee names (XYZ and PQR) in your gallery, follow these steps:
Create a Pie Chart for Priority:
Assume you have a table or collection called Assignees with columns AssigneeName, Priority, and Type.
Add a combo box (let’s call it ComboBoxAssignee) to your canvas app and set its Items property to: Distinct(Assignees, AssigneeName)
Create a pie chart control and set its Items property to:
ShowColumns( AddColumns( GroupBy( Filter(Assignees, AssigneeName = ComboBoxAssignee.Selected.Result || IsBlank(ComboBoxAssignee.Selected)), "Priority", "PriorityGroup" ), "Count", CountRows(PriorityGroup), "Label", Priority & ":" & CountRows(PriorityGroup) ), "Label", "Count" )
This will display a pie chart showing the count of each priority when an assignee (either XYZ or PQR) is selected in the gallery.
Create a Pie Chart for Type:
Similarly, create another pie chart control and set its Items property to:
ShowColumns( AddColumns( GroupBy( Filter(Assignees, AssigneeName = ComboBoxAssignee.Selected.Result || IsBlank(ComboBoxAssignee.Selected)), "Type", "TypeGroup" ), "Count", CountRows(TypeGroup), "Label", Type & ":" & CountRows(TypeGroup) ), "Label", "Count" )
This will display a pie chart showing the count of each type when an assignee (either XYZ or PQR) is selected in the gallery.
Remember to adjust the table or collection names and column names according to your actual data.

If you have any further questions or need additional assistance, feel free to ask! 😊

If this post helps, then Click on the Thumbs Up below and Accept it as the solution to help others.

Thanks,

Robu1.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @PAJ,

Could you please tell me how you set the Items property pof your Gallery?

This decides how you refer to gallery selected assignee name and Priority.

AddColumns(GroupBy(Filter(data,'Assignee Name'=Gallery.Selected.'Assignee Name'),"Priority","PG"),"PCount",CountRows(PG))

Note that you need to refer to correct returned column name in your Gallery, I refer to 'Assignee Name' directly, you need to check how you set the Text property of the Label where you display 'Assignee Name', the field name after ThisItem is the real field name you need to refer to.

Same as Type PieChart:

AddColumns(GroupBy(Filter(data,'Assignee Name'=Gallery.Selected.'Assignee Name'),"Type","TG"),"TCount",CountRows(TG))

Was this reply helpful? Yes No
PAJ 280 on at

Like (0)

Report

Thank you it worked . Any tips on how i can practice these formulas ?

Was this reply helpful? Yes No
Robu1 1,459 Super User 2025 Season 2 on at

Like (0)

Report
Hi @PAJ,

Certainly! Practicing Power Apps formulas is essential to become proficient in building apps. Here are some effective ways to practice:
Learn the Basics:
Familiarize yourself with the basic functions and operators used in Power Apps.
Understand how to manipulate data, create variables, and work with controls.
Explore the Formula Reference:
Refer to the Power Apps Formula Reference on Microsoft Learn.
This comprehensive resource provides details about various functions, signals, enumerations, and more 1.
Watch Tutorials and Webinars:
Check out webinars and video tutorials that cover Power Apps formulas.
For example, there’s a webinar specifically focused on 7 Power Apps formulas you should start using 2.
Create Mini Projects:
Build small apps or prototypes using different formulas.
Create a simple expense tracker, a task manager, or a contact list app.
Apply formulas for data validation, navigation, and user interactions.
Experiment with Real Data:
Use sample data or connect to external data sources (like SharePoint or SQL databases).
Practice retrieving, filtering, and displaying data using formulas.
Challenge Yourself:
Set specific tasks or challenges related to app development.
For instance, create a form with conditional visibility, implement cascading dropdowns, or calculate aggregate values.
Join Communities and Forums:
Participate in Power Apps communities, forums, and discussion groups.
Share your formulas, ask questions, and learn from others’ experiences.
Remember that consistent practice and hands-on experience are key to mastering Power Apps formulas. Start with simple tasks and gradually tackle more complex scenarios.

Happy app-building! 😊🚀📱

1 people found this reply helpful.

Was this reply helpful? Yes No