Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
prinuce
Helper I
Helper I

task utilization dashboard

‎03-31-2021 10:29 PM
Hi Team, Need some help in power bi. Actually i m creating power bi resource dashboard. But need some help. my requirement is to calcuation from today to next upcoming 3 month task. where the resource is utilized in task and percentage calculation who is free this time and when he will be free.  Please help me 

 


 

 
 
 
 
Labels:
Message 1 of 45
4,536 Views
0
1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

‎04-15-2021 02:44 AM

Hi @prinuce  ,


According to your description, I am a little confused. If you want to make a Gantt, you may need to have a %completion
column and a duration column, so I first added two columns, and then added to the Gantt chart, I hope it will help you:
Step 1: Add column( %complete)

% completion = IF('Sheet1 (2)'[Status]="In Progress",0.5,IF('Sheet1 (2)'[Status]="Complete",1,0))

Add another column:

Duration = DATEDIFF('Sheet1 (2)'[Start Date],'Sheet1 (2)'[End Date],DAY)

Step2:Add gantt visual
gantt.jpg
The final output is shown below:
gantt2.jpg
Best Regards,
Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

How to get your questions answered quickly -- How to provide sample data

View solution in original post

Message 44 of 45
4,326 Views
44 REPLIES 44
v-yalanwu-msft
Community Support
Community Support

‎04-15-2021 02:44 AM

Hi @prinuce  ,


According to your description, I am a little confused. If you want to make a Gantt, you may need to have a %completion
column and a duration column, so I first added two columns, and then added to the Gantt chart, I hope it will help you:
Step 1: Add column( %complete)

% completion = IF('Sheet1 (2)'[Status]="In Progress",0.5,IF('Sheet1 (2)'[Status]="Complete",1,0))

Add another column:

Duration = DATEDIFF('Sheet1 (2)'[Start Date],'Sheet1 (2)'[End Date],DAY)

Step2:Add gantt visual
gantt.jpg
The final output is shown below:
gantt2.jpg
Best Regards,
Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

How to get your questions answered quickly -- How to provide sample data
Message 44 of 45
4,327 Views
prinuce
Helper I
Helper I
In response to v-yalanwu-msft

‎04-18-2021 11:14 PM

Kudos! Team

Message 45 of 45
3,453 Views
0
prinuce
Helper I
Helper I

‎04-04-2021 09:36 AM

Please help

Message 43 of 45
3,540 Views
0
prinuce
Helper I
Helper I

‎04-03-2021 10:54 PM

Sir i m creating gantt visualization. Please help how to do % of completion of task. we have start date and end date column

please help me.

  Task list.xlsx

Message 42 of 45
3,576 Views
0
amitchandak
Super User
Super User

‎03-31-2021 10:36 PM

@prinuce ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Message 2 of 45
3,651 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:27 AM

Sie, please respond

Message 41 of 45
3,498 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:24 AM

Sie, please respond

Message 40 of 45
3,498 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:21 AM

Sie, please respond

Message 39 of 45
3,498 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:19 AM

Sie, please respond

Message 38 of 45
3,492 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:16 AM

Sie, please respond

Message 37 of 45
3,492 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:13 AM

Sie, please respond

Message 36 of 45
3,492 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:10 AM

Sie, please respond

Message 35 of 45
3,492 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:08 AM

Sie, please respond

Message 34 of 45
3,492 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:05 AM

Sie, please respond

Message 33 of 45
3,492 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:02 AM

Sie, please respond

Message 32 of 45
3,492 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 02:59 AM

Sie, please respond

Message 31 of 45
3,492 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 02:57 AM

Sie, please respond

Message 30 of 45
3,492 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 02:54 AM

Sie, please respond

Message 29 of 45
3,492 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 02:51 AM

Sie, please respond

Message 28 of 45
3,491 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 02:49 AM

Sie, please respond

Message 27 of 45
3,491 Views
0

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All