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

Пікірлер: 97

  • @dougydoe
    @dougydoe3 ай бұрын

    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

    @RezaDorrani

    3 ай бұрын

    Awesome!!!

  • @aminedoumandji6290
    @aminedoumandji62903 ай бұрын

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

  • @luisfernandomacedo1451
    @luisfernandomacedo14513 ай бұрын

    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

    @RezaDorrani

    3 ай бұрын

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

  • @attilagubacsi9885
    @attilagubacsi98853 ай бұрын

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

  • @rajaamohammed6965
    @rajaamohammed69653 ай бұрын

    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!

  • @krishnapatil7918
    @krishnapatil79183 ай бұрын

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

  • @iamdeepshekhar
    @iamdeepshekhar4 күн бұрын

    Great content!! Thank you for such valuable content🙂

  • @RezaDorrani

    @RezaDorrani

    4 күн бұрын

    Most welcome

  • @simonball5602
    @simonball56024 ай бұрын

    You’re a genius Reza. Thank you.

  • @georgegualda4262
    @georgegualda42624 ай бұрын

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

  • @mdizzle1369
    @mdizzle1369Ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Ай бұрын

    Most welcome

  • @vinhhienletran
    @vinhhienletran4 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    My pleasure!

  • @user-sm7kr8ok2m
    @user-sm7kr8ok2m4 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    You're welcome!

  • @oluwatobiyusuf
    @oluwatobiyusufАй бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Ай бұрын

    Have fun!

  • @bwebmasta1
    @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

    @RezaDorrani

    Ай бұрын

    Thanks for watching

  • @kangarooleague
    @kangarooleague4 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    You're welcome

  • @0135827
    @01358272 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    2 ай бұрын

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

  • @imran002ali
    @imran002ali4 ай бұрын

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

  • @Pbairoju
    @Pbairoju2 ай бұрын

    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

    @RezaDorrani

    2 ай бұрын

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

  • @AshutoshDubeyCivil
    @AshutoshDubeyCivil4 ай бұрын

    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

    @AshutoshDubeyCivil

    4 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    More videos will be dependent upon how this video does.

  • @claudycharles7123
    @claudycharles71234 ай бұрын

    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

    @RezaDorrani

    4 ай бұрын

    Thank you very much!

  • @alexandremartins8979
    @alexandremartins89793 ай бұрын

    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

    @RezaDorrani

    3 ай бұрын

    I have no idea about that

  • @paular7261
    @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

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

    @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)

  • @KaiWeissmann
    @KaiWeissmann4 ай бұрын

    Thanks for the amazing content!

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    Glad you enjoyed it!

  • @olisaemekaaghabuilo8688
    @olisaemekaaghabuilo86883 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    Thanks so much

  • @oscarcoronel2000
    @oscarcoronel20003 ай бұрын

    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

    @RezaDorrani

    3 ай бұрын

    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

  • @zerocool200380
    @zerocool2003804 ай бұрын

    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

    @RezaDorrani

    4 ай бұрын

    Yes, Pbi tIle needs a license for every user

  • @Fee459
    @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

    @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

  • @youtube_Salim
    @youtube_Salim3 ай бұрын

    Thank you Reza

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    Welcome

  • @john3434341
    @john34343413 ай бұрын

    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

    @RezaDorrani

    3 ай бұрын

    I do not

  • @snehanaz8710
    @snehanaz87106 күн бұрын

    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

    @RezaDorrani

    6 күн бұрын

    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

  • @gunasekaran4288
    @gunasekaran42884 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

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

  • @ahmadavisienagaza2115
    @ahmadavisienagaza211513 күн бұрын

    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

    @RezaDorrani

    13 күн бұрын

    I don’t know why.

  • @praveeng3921
    @praveeng39214 ай бұрын

    Waiting for this.❤

  • @rihabhamila4080

    @rihabhamila4080

    4 ай бұрын

    same here 😌

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    Video is live

  • @rihabhamila4080

    @rihabhamila4080

    4 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    @@rihabhamila4080 😊

  • @hamidaahmed4869
    @hamidaahmed48693 ай бұрын

    nice

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    Thanks

  • @OEzzat1
    @OEzzat13 ай бұрын

    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

    @RezaDorrani

    3 ай бұрын

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

  • @OEzzat1

    @OEzzat1

    2 ай бұрын

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

    @OEzzat1

    2 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    2 ай бұрын

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

  • @gunasekaran4288
    @gunasekaran42884 ай бұрын

    Same can we do in power apps chart??

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

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

  • @Rasec-Gonzalez
    @Rasec-Gonzalez3 ай бұрын

    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 KZread but they have not given me results. I do not have access to Premium connectors. Thank you for reading.

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

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

  • @itqawithakhil
    @itqawithakhil3 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    Group by department and then sum on salary

  • @itqawithakhil

    @itqawithakhil

    3 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    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
    @LasanthaNawarathna3 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    Is there a question?

  • @kamalakarreddyuppala3772
    @kamalakarreddyuppala37723 ай бұрын

    can we add power app combobox show all sp active sites

  • @kamalakarreddyuppala3772

    @kamalakarreddyuppala3772

    3 ай бұрын

    give any url

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

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

  • @kamalakarreddyuppala3772

    @kamalakarreddyuppala3772

    3 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

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

  • @kamalakarreddyuppala3772

    @kamalakarreddyuppala3772

    3 ай бұрын

    @@RezaDorrani Thanks Reza for your Replying messages

  • @manikantamorla6058
    @manikantamorla60583 ай бұрын

    How to print multiple screens on single click

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    Print function does not support that

  • @johnle1723
    @johnle172314 күн бұрын

    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

    @RezaDorrani

    14 күн бұрын

    Ok

  • @user-zd7br2xd6c
    @user-zd7br2xd6c2 ай бұрын

    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

    @RezaDorrani

    2 ай бұрын

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

Келесі