Forum Discussion

minap's avatar
minap
Regular Visitor
1 year ago

Visual showing Project progression, rag status, remaining days left and order by priority.

Im trying to replicate an excel chart in Powerbi, where it show each projects, progression its rag status and the days remaining like below can anyone help, I have tried clustered bar chart, gantt ch...
Need Help
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
1 year ago

minap  Kindly share sample data with dummy records to understand your scenario.

 

 

minap's avatar
minap
Regular Visitor
1 year ago

Thank you Tahreem24 

 

whats the best way to share the pbix file without including sensitve data ?

  • minap's avatar
    minap
    Regular Visitor
    1 year ago

    These are my measures

    Measures
    In Development = CALCULATE(countrows('Inflight Project Reviews'),FILTER('Inflight Project Reviews','Inflight Project Reviews'[Status]="In Development"))
    No Of Projects = COUNT('Inflight Project Reviews'[Project Code])
    On Hold = CALCULATE(countrows('Inflight Project Reviews'),FILTER('Inflight Project Reviews','Inflight Project Reviews'[Status]="On Hold"))
    Prioritised = CALCULATE(countrows('Inflight Project Reviews'),FILTER('Inflight Project Reviews','Inflight Project Reviews'[Status]="Prioritised"))
    Projects Completed = CALCULATE(countrows('Inflight Project Reviews'),FILTER('Inflight Project Reviews','Inflight Project Reviews'[Status]="Complete"))
    Ready For Development = CALCULATE(countrows('Inflight Project Reviews'),FILTER('Inflight Project Reviews','Inflight Project Reviews'[Status]="Ready For Development"))
    Scope Review = CALCULATE(countrows('Inflight Project Reviews'),FILTER('Inflight Project Reviews','Inflight Project Reviews'[Status]="Scope Review"))
    Waiting On Customer = CALCULATE(countrows('Inflight Project Reviews'),FILTER('Inflight Project Reviews','Inflight Project Reviews'[Status]="Waiting On Customer"))
    Waiting on Vendor = CALCULATE(countrows('Inflight Project Reviews'),FILTER('Inflight Project Reviews','Inflight Project Reviews'[Status]="Waiting on Vendor"))
    WIP = CALCULATE(countrows('Inflight Project Reviews'),FILTER('Inflight Project Reviews','Inflight Project Reviews'[Status]="WIP"))
    DaysDelayed = DATEDIFF(SELECTEDVALUE('Inflight Project Reviews'[ProposedGoLiveDate]), TODAY(), DAY)
    Days Used = DATEDIFF('Inflight Project Reviews'[Estimated Days],'Inflight Project Reviews'[Days Remaining],DAY)
    Days Remaining = DATEDIFF(TODAY(),SELECTEDVALUE('Inflight Project Reviews'[ProposedGoLiveDate]),DAY)
    Days Overrun = (DATEDIFF('Inflight Project Reviews'[Days Used],SELECTEDVALUE('Inflight Project Reviews'[ProposedGoLiveDate]),DAY))
    Estimated Days = DATEDIFF(SELECTEDVALUE('Inflight Project Reviews'[ProjectStartDate]),SELECTEDVALUE('Inflight Project Reviews'[ProposedGoLiveDate]),DAY)