Answered

Create a project progress graph

(0) Share

Report

Posted on by JakubN

Hello Power apps team,

I am trying to create a dashboard where there would be project status shown in a chart. I would like to match Project phase on axis with project. Then filter by region, search etc the regular functions. I tried to seach and I could not find a someone expainning how to build such dashbaord, or where to start, two galleries? One vertical with Projects one horizontal wiht status and then somehow create bar? What I am trying to achieve is below, if anyone has idea or a link to instructions, that would be highly appreciated.

Thank you.

Jakub

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

graeme_findlay 47 on at

Like (0)

Report
Copy link

Link copied!

you could insert a chart and use a switch to assign an increasing numerical value to your phases.

Was this reply helpful? Yes No
Verified answer

graeme_findlay 47 on at

Like (1)

Report
Copy link

Link copied!

Cancel my last, I just found this brilliant tutorial

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-create-a-horizontal-column-chart-Tutorial/td-p/149488

And used it to create your bar chart

The formula I used for the width of the rectangle was Switch(ThisItem.Phase,"Sizing",200,"MTP",400,"Testing",600,"First Transaction",800,"Completed",1000)

Obviously you would need to put in your axes outside the container of the vertical gallery, but it works 😄

Was this reply helpful? Yes No
graeme_findlay 47 on at

Like (0)

Report
Copy link

Link copied!

@JakubN let me know if this works for you, it took me a while to remember to add content to my blank vertical gallery 🙄

Please accept it as a solution if you've got it all working 😀

Was this reply helpful? Yes No
JakubN 41 on at

Like (1)

Report
Copy link

Link copied!

You solved my problem, thank you.

Was this reply helpful? Yes No
graeme_findlay 47 on at

Like (0)

Report
Copy link

Link copied!

Brilliant, I’m glad it worked for you 🙂

Was this reply helpful? Yes No