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. 🤣🤣
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:)
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!
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🙂.
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.
@bwebmasta1 were you able to figure out how to get total amounts from a numeric column, I am trying to do the same thing and I would appreciate any information you have learnt. Thanks
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...
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. :)
Love the video, it is very helpful. I was wondering if on the pie chart is there a way to filter the data by date? I only want to show the information for the previous month.
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?
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...
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)
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.
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
many thanks for sharing this handy material. can you help me with one question? I want to see the grand total of the pie graphics, let say, the addition of all portions. can you guide me up?
Most welcome! I would have to try out the grand total scenario to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Is it possible to associate a color with the "Label" from your PieChart example? I want to create a "universal" chart where I will load different companies and the department will always be in the same color on the chart? For example, "IT" will always be blue and "Sales" green.
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
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
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
@@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 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
My rule for topic suggestions is set - " Every 6-8 months I ask for topic suggestions on community tab of my channel. Make sure to post this idea there. If it gets max votes, I will add the topic to my backlog."
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
in powerapps line chart , Line width shown in video and line width shown on powerapps is different. Any idea how to increase line thickness in line chart. I am unable to find any property related to that
I don't remember the property name or what exactly was done for it. You can try downloading the solution shown in video (members only - check video description for details)
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
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
Hi I have created a pie chart but not able to select an item so table data is not displayed. I also keep display mode property as edit still not work. Can you help me on that?
I have not experienced the mentioned issue and hence not sure of the cause or fix for it. I will recommend checking or posting your issue on forums in case someone has experienced something similar community.powerplatform.com/
Most welcome! I do not have a specific video reference on the mentioned scenario and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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.
I have not experienced the mentioned issue, hence not sure whats the cause for your issue. You can try downloading the solution shown in video (members only - check video description for details)
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 RUclips but they have not given me results. I do not have access to Premium connectors. Thank you for reading.
Hi Reza, I love the way you explain things. Anyone would understand it. Thank you for your time and effort for creating such videos. I think something has changed in powerapps and instead of Department in "" try using ''. Instead of "Department", use 'Department'. This has worked for me - AddColumns(GroupBy(AddColumns(ShowColumns('Patient Feedback Form','Department', 'Patient Name'), Department_Column1,Department.Value),Department_Column1,'Grp_Department'), 'Number Of Users', CountRows(ThisRecord.Grp_Department))
@@RezaDorrani Tried. Unsuccessful. No error in formula but the table's blank. Let me see if i superimpose another table and change its visible properties.
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
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.
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',")"))
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
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. 🤣🤣
Awesome!!!
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:)
Thanks so much!
Video viewership is a good parameter for how successful a topic is. This one currently has low views.
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!
Came here to learn about charts controls in Canvas and left with much more than this.
Thanks again Reza
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🙂.
Glad you like them! I will keep trying my best as long as more and more folks keep watching and sharing the videos.
Absolutely fantastic video.
Clear, focused explanations with very practical examples.
Congrats!
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.
Thanks for watching
@bwebmasta1 were you able to figure out how to get total amounts from a numeric column, I am trying to do the same thing and I would appreciate any information you have learnt. Thanks
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...
I think lot of permutations can be explored in charts and filtering.. ❤
More videos will be dependent upon how this video does.
OMG Reza I love the way you delivered it! Can't thank you enough for your videos!
My pleasure!
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. :)
Thank you very much!
Love the video, it is very helpful.
I was wondering if on the pie chart is there a way to filter the data by date? I only want to show the information for the previous month.
Most welcome!
My guess would be yes but not something I have tried or have a video reference for.
TY the bar chart info helped me a bunch! I never knew where to find the color properties.
Most welcome
Thanks Reza, you always surprise us with your wonderful videos !!!
Most welcome!
I’ll try my best to keep surprising with new topics
I have not used the chart before, now will be best to try it out. Thank you Reza
Have fun!
WOW.... Excellent video as always you out do yourself.
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?
I have no idea about that
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...
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)
As always, great video Reza 😊. Appreciate your work.
Reza, Great video. For the PowerBi Tile, am I right to assume that all users should have a PowerBi license to view the tile?
Yes, Pbi tIle needs a license for every user
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.
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
Hi Reza, thanks for the video. Also wanted to ask if there was a way to embedding the charts in html probably triggered using power automate ? Thanks
I have not tried scenario on embedding charts in html, hence not sure
many thanks for sharing this handy material. can you help me with one question? I want to see the grand total of the pie graphics, let say, the addition of all portions. can you guide me up?
Most welcome!
I would have to try out the grand total scenario to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
This is just what I needed. Thanks for the great video!
You're welcome!
Hi, do you know if it's possible to change the size of the pie chart without changing the height and width of the container?
Pie chart if in container would be limited to container dimensions
Is it possible to associate a color with the "Label" from your PieChart example? I want to create a "universal" chart where I will load different companies and the department will always be in the same color on the chart? For example, "IT" will always be blue and "Sales" green.
It should be possible (guess) but not something I have tried
@@RezaDorrani Ok. Thanks. And thanks for your content, its great :)
Excellent video Reza! Thanks so much!
Glad you enjoyed it!
Thank you for your explanation! It helped me a lot.
You are most welcome!
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
I have not experienced this hence not sure
Raza. I will say you are very good at what you do. Thanks for your wonderful contents.
Thanks so much
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
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
Hi Reza, why I unable to find the last part , when I put in “label” can’t find the number of user , but the data are into the table.
I have not experienced the mentioned issue, hence not sure whats the cause for your issue.
You can try downloading the app as silver or gold member.
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?
Thanks!
Sorry but I do not offer 1:1 consulting. My business email is in "About" tab of my channel.
@@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,
" ) "
)
)
)
)
and i need to know if can use the same code for column chart and line chart please
@@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
Great content!! Thank you for such valuable content🙂
Most welcome
Please create a video for running total or cumulative sum in power apps filtered by date category
My rule for topic suggestions is set - "
Every 6-8 months I ask for topic suggestions on community tab of my channel. Make sure to post this idea there. If it gets max votes, I will add the topic to my backlog."
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 ?
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
in powerapps line chart , Line width shown in video and line width shown on powerapps is different. Any idea how to increase line thickness in line chart. I am unable to find any property related to that
I don't remember the property name or what exactly was done for it.
You can try downloading the solution shown in video (members only - check video description for details)
You’re a genius Reza. Thank you.
Thank you! ANd its even uploaded 10 hours ago!!! Superb!!!!
You're welcome
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
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
Thanks for the amazing content!
Glad you enjoyed it!
Hi Reza, great video, very helpful, thank you! 👍
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'
I don’t know why.
Hi I have created a pie chart but not able to select an item so table data is not displayed. I also keep display mode property as edit still not work. Can you help me on that?
I have not experienced the mentioned issue and hence not sure of the cause or fix for it.
I will recommend checking or posting your issue on forums in case someone has experienced something similar
community.powerplatform.com/
i dont understand o/a 1:38 when you added a button. the video jumped so i didn't see what you clicked on
Looks like you found it based on another comment
Great job, thanks
Most welcome
Thanks sir
I need piechart generation dynamically using api response pls help
Most welcome!
I do not have a specific video reference on the mentioned scenario and would have to try it out to provide guidance.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Can you teach power apps chart with all the column scenarios..because we dont have power bi licenses
The video is on Power Apps charts and not on power bi.
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.
I do not
Hi Reza, what if my count cross the limit of 2k will that get me the count ?
Countrows is delegable with Dataverse but not SharePoint
@@RezaDorrani Hi thanks so is there any other way to get the count ? Any other work around please
@@sridharreddy1607 Im not aware of a workaround.
In my powerapps ClearCollect, addcolumns these are not working. I am in edit mode. Do you know whats the possible reason?
I have not experienced the mentioned issue, hence not sure whats the cause for your issue.
You can try downloading the solution shown in video (members only - check video description for details)
Waiting for this.❤
same here 😌
Video is live
I ment w've been waiting for you to do a video on Chart Controls 🙂@@RezaDorrani
@@RihabHamila 😊
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 RUclips but they have not given me results. I do not have access to Premium connectors. Thank you for reading.
Thanks for the suggestion. If this video gets max votes (likes), I will add it to my list.
Same can we do in power apps chart??
The video is on Power Apps charts and not on power bi.
Hi Reza, how can we do if we want total salaries in each department.
Group by department and then sum on salary
@@RezaDorrani I Tried but it's showing the total of salaries in the list
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/
Thank you Reza
Welcome
Hi Reza, I love the way you explain things. Anyone would understand it. Thank you for your time and effort for creating such videos.
I think something has changed in powerapps and instead of Department in "" try using ''. Instead of "Department", use 'Department'.
This has worked for me - AddColumns(GroupBy(AddColumns(ShowColumns('Patient Feedback Form','Department', 'Patient Name'), Department_Column1,Department.Value),Department_Column1,'Grp_Department'),
'Number Of Users', CountRows(ThisRecord.Grp_Department))
May be but can also depend upon regional settings
@@naveendas9173 I have not tried the mentioned scenario, hence not sure
@@RezaDorrani Tried. Unsuccessful. No error in formula but the table's blank. Let me see if i superimpose another table and change its visible properties.
@@naveendas9173 I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
i got one error, i trying to resolving but it is not working Please help me.
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
can we add power app combobox show all sp active sites
give any url
You mean SharePoint sites?
Not sure about that. I have not tried that.
@@RezaDorrani recent requirement show all sp sites in combobox when user click site show all lists
@@kamalakarreddyuppala3772 Not something I have tried so not sure.
@@RezaDorrani Thanks Reza for your Replying messages
hello , i need th app link please
Shared on the other message you posted
@ thank you Reza , you are the man
nice
Thanks
How to print multiple screens on single click
Print function does not support that
AddColumns(GroupBy('SPListName',"Department", "DepartData"), "DepartCount", CountRows(DepartData))
Is there a question?
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.
Ok
nevermind i found it
Ok
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',")"))
I am assuming you have shared the formula for others reference. Thanks for that.