CHART Controls in Power Apps | Line, Column, and Pie Charts

Deep dive into the world of Power Apps CHART Controls! Explore Line, Column, and Pie Charts in this PowerApps tutorial video.
Column chart, Pie chart & Line chart are grouped controls. Each group contains three controls: a Label for the title, the chart graphic, and a Legend.
Discover how to set the number of series, fine-tune chart control properties, and seamlessly connect charts to collections and data sources.
Learn advanced techniques, including utilizing table shaping formulas such as GroupBy, AddColumns, CountRows, and more to refine and better shape your data.
Let's explore how we can use the Chart controls in Power Apps to visualize data.
#PowerApps #PowerPlatform #Charts #CanvasApps
⬇️ Download Chart based Power App ➡️ link in Community Tab for Channel Members (Silver Club 🥈 or higher)
Table of Contents:
00:00 - Introduction to CHART controls in Power Apps
00:30 - 3 Types of charts in Power Apps
00:56 - Column Chart in PowerApps
03:44 - Line chart in PowerApps
04:09 - Power Apps Pie Chart
04:50 - Power Apps Table Shaping Formulas (GroupBy, AddColumns)
06:52 - Connect Chart controls to data source (SharePoint List)
10:45 - Chart control OnSelect action
11:52 - Demo of Chart Control in Power Apps

[@dougydoe]

Never used the Chart control before in any project so to see this and the user of Filters, AddColumns etc is Brilliant! Will definitely download the solution and watch again. I'm pretty sure I'll find a usecase where I can implement some of the knowledge from this video. You really do help me think outside the box... Thank you. 🤣🤣

[@RezaDorrani]

Awesome!!!

[@attilagubacsi9885]

Absolutely fantastic video. Clear, focused explanations with very practical examples. Congrats!

[@aminedoumandji6290]

Came here to learn about charts controls in Canvas and left with much more than this. Thanks again Reza

[@caiosutile]

Thank you for your explanation! It helped me a lot.

[@RezaDorrani]

You are most welcome!

[@luisfernandomacedo1451]

Reza, I've mentioned this, and am gonna do it again: You're the wizard of Power Apps. Bring more content related to charts in Power Apps. We'd appreciate it:)

[@RezaDorrani]

Thanks so much! Video viewership is a good parameter for how successful a topic is. This one currently has low views.

[@krishnapatil7918]

As always, great video Reza 😊. Appreciate your work.

[@simonball5602]

You’re a genius Reza. Thank you.

[@georgegualda4262]

WOW.... Excellent video as always you out do yourself.

[@rajaamohammed6965]

Just a quick note to express my sincere appreciation for your Power Apps video. It seems to be a subset of Power BI Thanks for making learning so enjoyable!

[@vinhhienletran]

OMG Reza I love the way you delivered it! Can't thank you enough for your videos!

[@RezaDorrani]

My pleasure!

[@MichaelDeBlasis1369]

TY the bar chart info helped me a bunch! I never knew where to find the color properties.

[@RezaDorrani]

Most welcome

[@iamdeepshekhar]

Great content!! Thank you for such valuable content🙂

[@RezaDorrani]

Most welcome

[@user-sm7kr8ok2m]

This is just what I needed. Thanks for the great video!

[@RezaDorrani]

You're welcome!

[@imran002ali]

Hi Reza, great video, very helpful, thank you! 👍

[@0135827]

Thanks Reza, you always surprise us with your wonderful videos !!!

[@RezaDorrani]

Most welcome! I’ll try my best to keep surprising with new topics

[@kangarooleague]

Thank you! ANd its even uploaded 10 hours ago!!! Superb!!!!

[@RezaDorrani]

You're welcome

[@oluwatobiyusuf]

I have not used the chart before, now will be best to try it out. Thank you Reza

[@RezaDorrani]

Have fun!

[@KaiWeissmann]

Thanks for the amazing content!

[@RezaDorrani]

Glad you enjoyed it!

[@claudycharles7123]

Excellent tutorial, Reza. You've done a remarkable job using these functions, truly amazing ideas. Your creativity and innovative thinking are truly inspiring. Thank you very much. :)

[@RezaDorrani]

Thank you very much!

[@bwebmasta1]

Great video as usual! This really helps with clear and concise examples. Some things I am working on figuring out are: displaying the total amount of a numeric column at the bottom of a table and filtering on a table to display items for each respective month based on the created column.

[@RezaDorrani]

Thanks for watching

[@Pbairoju]

Hi Reza, you are uploading great videos every time. Honestly speaking, getting more detailed information from your videos on PowerAps, Please keep going and make us experts in PowerApps like you🙂.

[@RezaDorrani]

Glad you like them! I will keep trying my best as long as more and more folks keep watching and sharing the videos.

[@AshutoshDubeyCivil]

Hi Reza.. Bravo.... This I asked you 3 months back if you remember.... Thanks for sharing... Need additional Power Bi video too.. and in-depth for charts like in Excel...

[@AshutoshDubeyCivil]

I think lot of permutations can be explored in charts and filtering.. ❤

[@RezaDorrani]

More videos will be dependent upon how this video does.

[@olisaemekaaghabuilo8688]

Raza. I will say you are very good at what you do. Thanks for your wonderful contents.

[@RezaDorrani]

Thanks so much

[@youtube_Salim]

Thank you Reza

[@RezaDorrani]

Welcome

[@alexandremartins8979]

Hello Reza, your videos help me a lot. I have a question, the option "Window Trigger Start Token" refers to the time when the flow was triggered or the time when the run ends?

[@RezaDorrani]

I have no idea about that

[@zerocool200380]

Reza, Great video. For the PowerBi Tile, am I right to assume that all users should have a PowerBi license to view the tile?

[@RezaDorrani]

Yes, Pbi tIle needs a license for every user

[@paular7261]

Your videos are amazing. Question: i have a pie chart that uses a SharePoint as data source and based on what i select in the pie chart, i have it so it filters the gallery also pointing yo dame SharePoint data source. But im mentally confused/blocked how to have both the pie chart and a drop down box or maybe a search box both be able to use to filter the gallery.

[@RezaDorrani]

Most welcome! I have not tried multi filter approach with pie chart and other controls. Not sure if there is some limitation there. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@johnhatcher579]

Hi Reza, love your post - question, How do you clear a Column Chart Selection? In a pie chart all you have to do is click outside of the visual, bit not so with the column chart. Even when I clear the display the chart still holds onto the last column selected. The column chart is only clear when the Screen first opens or when the screen losses focus...

[@RezaDorrani]

I did not notice that. Might well be a limitation of that control. One option may be is add a reset button. Onclick navigate to an empty screen and back (on visible of screen use back() function)

[@praveeng3921]

Waiting for this.❤

[@rihabhamila4080]

same here 😌

[@RezaDorrani]

Video is live

[@rihabhamila4080]

I ment w've been waiting for you to do a video on Chart Controls 🙂@@RezaDorrani

[@RezaDorrani]

@@rihabhamila4080 😊

[@oscarcoronel2000]

Im having problems with my powerapps, I have a multiple galleries with a save button, this button saves the whole gallery + the Goal. The problem is that if someone click the button at the same time as other user, it gets Network error. Also, if they do not refresh, the value of Goal will be the one that they have rather than the actual one. Do you have any video with multiple users on one powerapps using patch functions? Thanks! Your videos are really helpful

[@RezaDorrani]

I do not have a video reference on this scenario. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@hamidaahmed4869]

nice

[@RezaDorrani]

Thanks

[@Fee459]

Hi Reza, thanks for this vidéo. I have an issue in the series of my graph. It does not show all available elements from my gallery. How Does it come ?

[@RezaDorrani]

Welcome! I have not come across any issues and hence not sure what the cause for it could be. I will recommend posting your issue/query on forums in case someone has experienced something similar

[@mikehubbard2102]

Hello Reza. Have you ever come across creating charts where there are no Advanced Properties displayed? I have inserted a line chart and connected it to a SharePoint list as a data source. Once I click on the Line Chart property and proceed to make changes within the Advanced Properties it's blank. Could have to do with the modern controls and how they are setup? Thank you as always

[@RezaDorrani]

I have not experienced this hence not sure

[@gunasekaran4288]

Can you teach power apps chart with all the column scenarios..because we dont have power bi licenses

[@RezaDorrani]

The video is on Power Apps charts and not on power bi.

[@OEzzat1]

Great video and apps as im a member ❤ , i have a really serious question to make a chart requirement and need assistance, is it possible?

[@RezaDorrani]

Thanks! Sorry but I do not offer 1:1 consulting. My business email is in "About" tab of my channel.

[@OEzzat1]

@@RezaDorrani alright , would you please check what i need in this code to show the chart series to have projects type for each departmenT ? Department column is a choice type name DepartmentsAll Clear(colStrategicAppData); ForAll( Choices(StrategicApp.'Type of project'), Collect( colStrategicAppData, AddColumns( AddColumns( GroupBy( AddColumns( ShowColumns( Filter( StrategicApp, 'Type of project'.Value = Value ), "Typeofproject" ), "Typeofproject_Name", Typeofproject.Value ), "Typeofproject_Name", "Grp_Typeofproject" ), "Count", CountRows(ThisRecord.Grp_Typeofproject) ), "Label", Concatenate( ThisRecord.Typeofproject_Name, " ( ", ThisRecord.Count, " ) " ) ) ) )

[@OEzzat1]

and i need to know if can use the same code for column chart and line chart please

[@RezaDorrani]

@@OEzzat1 I would need same data source as you + would have to try out the scenario. I have shared entire app and code with members (check description for details) Best to check code shared or post your query on forums at powerusers.microsoft.com

[@john3434341]

Do you have a video about the 5000 sharepoint limit for powerBI I can't seem to export my sharepoint for case related reporting to powerBI after reaching 5000.

[@RezaDorrani]

I do not

[@snehanaz8710]

I have a doubt, for suppose if the revenue is zero, then what all total revenue is zero i want to be invisible . Rest all can be visible. What can be visible property formula please guide

[@RezaDorrani]

I would have to try that to know the formula. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@ahmadavisienagaza2115]

I have written the exact same formula from 8:46, but why my column does not show the value? (I also use the list with data type 'choice'

[@RezaDorrani]

I don’t know why.

[@Rasec-Gonzalez]

Hello Reza, at the beginning of February I got a job as a Power Platform Developer, but I have had some problems with Power Automate, could you upload a video tutorial on how to bring the data from a sharepoint list and use it in a pdf or word template Dynamically, this template should appear some data from the sharepoint list and also some images. I have been watching videos on KZbin but they have not given me results. I do not have access to Premium connectors. Thank you for reading.

[@RezaDorrani]

Thanks for the suggestion. If this video gets max votes (likes), I will add it to my list.

[@gunasekaran4288]

Same can we do in power apps chart??

[@RezaDorrani]

The video is on Power Apps charts and not on power bi.

[@itqawithakhil]

Hi Reza, how can we do if we want total salaries in each department.

[@RezaDorrani]

Group by department and then sum on salary

[@itqawithakhil]

@@RezaDorrani I Tried but it's showing the total of salaries in the list

[@RezaDorrani]

I would have to try it out at my end to provide any support. Best to post your query on forums at powerusers.microsoft.com/

[@LasanthaNawarathna]

AddColumns(GroupBy('SPListName',"Department", "DepartData"), "DepartCount", CountRows(DepartData))

[@RezaDorrani]

Is there a question?

[@venkateswarlurayalla2117]

i got one error, i trying to resolving but it is not working Please help me.

[@RezaDorrani]

I have not faced any issues with this. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@kamalakarreddyuppala3772]

can we add power app combobox show all sp active sites

[@kamalakarreddyuppala3772]

give any url

[@RezaDorrani]

You mean SharePoint sites? Not sure about that. I have not tried that.

[@kamalakarreddyuppala3772]

@@RezaDorrani recent requirement show all sp sites in combobox when user click site show all lists

[@RezaDorrani]

@@kamalakarreddyuppala3772 Not something I have tried so not sure.

[@kamalakarreddyuppala3772]

@@RezaDorrani Thanks Reza for your Replying messages

[@manikantamorla6058]

How to print multiple screens on single click

[@RezaDorrani]

Print function does not support that

[@johnle1723]

Wow this just shows how bad powerapps is. If you are using input fields to patch into a table on sharepoint, it wont be able to do it simply because it relies on fields and not rows. So having a pie chart guide is quite useless given how restrained it is on what you can and cannot do.

[@RezaDorrani]

Ok

[@user-zd7br2xd6c]

AddColumns( AddColumns(GroupBy(AddColumns(ShowColumns('Employee data',"Department","Title"),"Department Name",Department.Value),"Department Name","Grp_Department"),"Number of emp",CountRows(ThisRecord.Grp_Department)),"Label",Concatenate('Department Name',"(",'Number of emp',")"))

[@RezaDorrani]

I am assuming you have shared the formula for others reference. Thanks for that.