Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have the following Columns Task, Due Date and EmployeeAssigned.
In a visual, I want to display the top 5 of the nearest due date from today. And display due date, EmployeeAssignedand task.
Do I need to work out the nearest due date from today?
what is the best way to display this visual
TIA
Solved! Go to Solution.
Hi,
PBI file attached.
Hope this helps.
you can use TOPN(5,FILTER(table))) to grab these data points.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Hello bendlin
sample dataset
Employee | Task | Days due (formula to work out) | DueDate (to be sorted to nearest date) |
EmployeeA | Annual Review Due | 8 days | 18/04/2024 |
EmployeeB | Annual Review Due | 10 days | 22/04/2024 |
EmployeeC | Supervision Due | 11 days | 23/04/2024 |
EmployeeD | Training Due | 13 days | 25/04/2024 |
EmployeeA | Training Due | 24 days | 9/05/2024 |
EmployeeM | Medical check due | 33 days | 22/05/2024 |
EmployeeF | Bushfire training | 2 days | 10/04/2024 |
I found this great example dashboard layout of tasks. This is what I would like to achieve/display
You are welcome.