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: 

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

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,694 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,484 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,485 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,513 Views
0
prinuce
Helper I
Helper I

‎04-04-2021 09:36 AM

Please help

Message 43 of 45
3,600 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,636 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,711 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:27 AM

Sie, please respond

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

‎04-06-2021 03:24 AM

Sie, please respond

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

‎04-06-2021 03:21 AM

Sie, please respond

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

‎04-06-2021 03:19 AM

Sie, please respond

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

‎04-06-2021 03:16 AM

Sie, please respond

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

‎04-06-2021 03:13 AM

Sie, please respond

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

‎04-06-2021 03:10 AM

Sie, please respond

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

‎04-06-2021 03:08 AM

Sie, please respond

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

‎04-06-2021 03:05 AM

Sie, please respond

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

‎04-06-2021 03:02 AM

Sie, please respond

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

‎04-06-2021 02:59 AM

Sie, please respond

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

‎04-06-2021 02:57 AM

Sie, please respond

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

‎04-06-2021 02:54 AM

Sie, please respond

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

‎04-06-2021 02:51 AM

Sie, please respond

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

‎04-06-2021 02:49 AM

Sie, please respond

Message 27 of 45
3,551 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.

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