Dashbored where he take stairs

[sahaalq]

Hello All

Please I need your help in accomplishing this challenge. i am trying to make a dynamic chart where a business man take steps in a stairs

i have built the steps chart but from simple table but i don't know how to link investors table to this chart.
in the dashboard i made a slicer for the name list of investor and i want to be able when i press the investor name to show me which stage he at in the stairs chart

i have attached the chart for more explanation...

[sahaalq]

Lets say investor : Company 1 he is in procurement Stage .


It should automatic write 3 in # for man running column


and in chart reflect the business man picture in procurement stage









Stages
# for steps
# for Stages
# for man Running


Register
0
1



DS due diligence
1
1



hold/cancelled
2
1



Procurement DD
3
1
3


prefeasibility
4
1




business case
5
1



Graduated
6
1

[sahaalq]

Please i Need your help guys

[snb]

Maybe here: https://www.pearstairs.co.uk/

[Paul_Hossler]

Maybe here: https://www.pearstairs.co.uk/

I understand that the OP asked for very broad and involved project that most likely won't get an answer here for free, but that wasn't particularly helpful