Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 chart but not working.
@minap Kindly share sample data with dummy records to understand your scenario.
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)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!