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: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
1,468 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
1,258 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
1,259 Views
prinuce
Helper I
Helper I
In response to v-yalanwu-msft

‎04-18-2021 11:14 PM

Kudos! Team

Message 45 of 45
1,047 Views
0
prinuce
Helper I
Helper I

‎04-04-2021 09:36 AM

Please help

Message 43 of 45
1,134 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
1,170 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.



Message 2 of 45
1,245 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:27 AM

Sie, please respond

Message 41 of 45
1,092 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:24 AM

Sie, please respond

Message 40 of 45
1,092 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:21 AM

Sie, please respond

Message 39 of 45
1,092 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:19 AM

Sie, please respond

Message 38 of 45
1,086 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:16 AM

Sie, please respond

Message 37 of 45
1,086 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:13 AM

Sie, please respond

Message 36 of 45
1,086 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:10 AM

Sie, please respond

Message 35 of 45
1,086 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:08 AM

Sie, please respond

Message 34 of 45
1,086 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:05 AM

Sie, please respond

Message 33 of 45
1,086 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 03:02 AM

Sie, please respond

Message 32 of 45
1,086 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 02:59 AM

Sie, please respond

Message 31 of 45
1,086 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 02:57 AM

Sie, please respond

Message 30 of 45
1,086 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 02:54 AM

Sie, please respond

Message 29 of 45
1,086 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 02:51 AM

Sie, please respond

Message 28 of 45
1,085 Views
0
Syndicate_Admin
Administrator
Administrator
In response to amitchandak

‎04-06-2021 02:49 AM

Sie, please respond

Message 27 of 45
1,085 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All
Top Solution Authors
View All