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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Monthly Project Completion

Hello Guys

 

I am really new to Power BI and I need your help,

 

Im trying to achieve this visual (link) 

 

https://app.powerbi.com/reportEmbed?reportId=34ec2a2e-9384-4829-9410-9a4ea8b4fd5a&autoAuth=true&ctid...

 

The problem is that I need a formula where I can create a measure stating closed date and start date.

 

The data I am working with is Project Name, Project Start Date and Project Finish Date

 

Is there anyway I can achieve the visual above.

 

 

Regards

 

 

1 ACCEPTED SOLUTION

hi, @Anonymous 

You could try to refer to this post I have solved:

https://community.powerbi.com/t5/Desktop/Track-the-Workload-by-counting-the-number-of-in-progress-ta...

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-lili6-msft
Community Support
Community Support

hi, @Anonymous 

It seems that we couldn't have access to this report.

To view this report, ask the author for access

Please share some data sample and the formula and expected output. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

I really apologise for that I have attached a picture of visualisation that I am trying to achieve

 

Capture.JPG

 

Here is the project data that Im trying to work this out with

Project data.JPG

 

So is there anyway that I can achiveve my visualisation as stated above? Thanks you in advance

 

Regards

hi, @Anonymous 

You could try to refer to this post I have solved:

https://community.powerbi.com/t5/Desktop/Track-the-Workload-by-counting-the-number-of-in-progress-ta...

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thank You Lin, really appreciate your help

 

Regards

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.