Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
minap
Regular Visitor

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 chart but not working. 

 

minap_0-1742765275511.png

 

3 REPLIES 3
Tahreem24
Super User
Super User

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

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Thank you @Tahreem24 

 

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

minap
Regular Visitor

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)

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors