in a visual display the top 5 due dates (from today) with task and Employee

[dd88]

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

[lbendlin]

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...

[dd88]

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

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[dd88]

Thank you @Ashish_Mathur 

[Ashish_Mathur]

You are welcome.