Showing results for 
Search instead for 
Did you mean: 
New Member

Percentage representation in data

I'll start by saying that I am a complete newbie to PowerBI, so please bare with me if the solution to my question is obvious.


I have a dataset where each row represents a task.

Columns represent datetime of task assignment, time (days) for task completion


There are a couple of things that I'd like to do for my presentation:

1. Generate a bar graph (0-->100% y-axis, year x-axis) where I can set a time threshold, and show which percentage of tasks were completed by the set threshold, each year. Ideally this could be done with a splicer function so that I could alter the threshold during presentation.


2. Similar to (1) above, but with multiple thresholds. So that I could show percentage of tasks being completed in 1 day, 1-5 days, >5 days. 


Any help would be much apprecaited. 


Re: Percentage representation in data



For your scenario, the best approach is using Gantt chart, which can display start date, completion percentage, duration, etc. For more details, please refer to this article: Visual Awesomeness Unlocked – Gantt chart


However, it's not possible dynamically specify a threshold, the chart always start at the earliest date in the data field you put under Start Date. You can calculate the completion percentage in different "bucket". But still, it can't be based on a dynamic threshold.



Helpful resources

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors