A Complete Feasibility Matrix in Power Apps for Project Management
2.3 هزار بار بازدید -
6 ماه پیش
-
This video is a continuation
This video is a continuation of Part1: • Creating a Business Value VS Feasibil...
We build an app to chart Business Value vs Feasibility. In the video we only use collections to create the chart, that means the data will not save. In order for the data to save you will need to Patch the data!
This is the complete feasibility matrix in power apps which could be incorporated into many different types of Matrix. A feasibility matrix is a tool used for evaluating multiple options or solutions against a set of criteria to determine their viability or practicality. It helps in comparing different alternatives based on factors such as cost, time, resources, and risk, enabling decision-makers to identify the most feasible option. The matrix simplifies complex decision-making processes by visually representing the strengths and weaknesses of each option, making it easier to assess and prioritize them.
If you have trouble patching, let me know I think I can make a Part3.
If you have other questions feel free to let me know in the comments. And THANK YOU for watching!
Youtube will not allow me to put the less than or equal than sign in the description, so just double check the formula!
circleColor code:
If(
LookUp(colCircles,ID = 1,Feasibility = 7) &&
LookUp(colCircles,ID = 1,BusValue = 3),
Color.Red,
If(
LookUp(colCircles,ID=1,Feasibility = 7) &&
LookUp(colCircles,ID=1,BusValue = 1),
Color.Orange,Color.Green)
)
X of a circle: LookUp(colCircles,ID=1,BusValue*57.5)
Y of a circle: LookUp(colCircles,ID=1,Feasibility*57.5)
Visible of a circle: If(varID=1,true,false)
lblID: LookUp(colCircles,ID=1,ID)
Chapters:
0:00 introduction
1:19 Creating a Component
4:07 Replacing our Circle with Component
7:45 Changing the Video based on the ID
8:45 Thinking about Coloring
9:30 Changing the Fill or circleColor
10:39 The Full Color code
13:30 Just inserting Rectangles and Changing Alpha
14:30 Conclusion
6 ماه پیش
در تاریخ 1403/01/06 منتشر شده
است.
2,348
بـار بازدید شده