Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dd88
Resolver I
Resolver I

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

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

1 ACCEPTED SOLUTION

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1712546285011.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
lbendlin
Super User
Super User

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

 

EmployeeTaskDays due (formula to work out)DueDate (to be sorted to nearest date)
EmployeeAAnnual Review Due8 days18/04/2024
EmployeeBAnnual Review Due10 days22/04/2024
EmployeeCSupervision Due11 days23/04/2024
EmployeeDTraining Due13 days25/04/2024
EmployeeATraining Due24 days9/05/2024
EmployeeMMedical check due 33 days22/05/2024
EmployeeFBushfire training 2 days10/04/2024

 

 

I found this great example dashboard layout of tasks. This is what I would like to achieve/display

 

Dashboard Tasks layout example.png

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1712546285011.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Thank you @Ashish_Mathur 

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.