Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone.
I'm creating a report for visualizing tasks from a project. I need a table with the name of the tasks, start and end dates, etc.
Problem is, part of the columns got Dates in their names, and the rows must show the % of advance to that task on that date. Thoose dates are a period selected by the user.
Something like that, but in Power BI.
Where the predicted % progress must be calculated based on business days between the start and end dates, so, if the task has 3 days of duration, it needs to be 33,33% each day (if theres no weekend and holidays between these 3 days). In that case, the image would show 100% for all dates of the period, since the period is always from seven to seven days.
In other words, I need to calculate the % based on the columns start and end dates, and then show it for each day of the selected period, wich must be presented in the columns.
My first try was creating a slicer so the user can filter the dates, and the columns must change based on the filter, like if the user filters 01/04/2023 as start date from the period, the columns must be like the imagem and show the values of %. Dates always needs to be minimum date filtered in the slicer + 7, + 14, + 21 and + 28. I tried doing that but I coulnd't.
I also tried doing this in PowerQuery, my idea was to save the name of the file with the start date of the period, so I can use it to do all the calculus and then just show it's results, without the slicer. But, I failed too.
Note that the % only depends from start and end date, but the user must see its advance on the period that he chooses.
The database is imported from MS Project.
I know that is not usual to show dates in columns names, but the user asked to be like this.
Is there a way to doint that? Or there's a better way to showing that information?
Read about NETWORKDAYS()
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
User | Count |
---|---|
77 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
100 | |
93 | |
52 | |
50 | |
48 |