I have an app that was created to track task catagories and the time spend on each catagory. The pie is presneted correctly but it will not load when the app initially runs. I have to either go to the new record screen and cancel or select the record edit screen then return to the browseGallery screen for the pie to be displayed. In the onVisible property of the Gallery control a collection is created an agregate column and the pie chart card item property is set to the new agregate column in the collection. How do I cause the pie to be generated at applicaton load?
Limitation: When you set the Items property of a Pie Chart to a Collection, you will have to add data into the Collection before anything shows up. Also, if you want to change any data to the Pie Chart, that requires you to recollect it to reflect changes.
As an alternative, the Table() function is perfect for the Items property of the Pie Chart because it show real-time data. You do not need to recollect data. It's probably the most underrated function in PowerApps since connected datasources are emphasized so much.
Below is an example of a formula used to summarize the level of proficiency of students as a whole: