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:)
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...
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.
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🙂.
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
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. :)
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)
@@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
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?
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
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
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
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.
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 RU-vid but they have not given me results. I do not have access to Premium connectors. Thank you for reading.
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',")"))
