cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jaxidian Regular Visitor
Regular Visitor

How can I do a Top N by Date in a Table?

Let's say I have a few visualizations of accounts (sales, profits, etc.) but I also want to have a Table visualization that shows the Top 10 accounts with contracts expiring soon (let's say the AccountExpirationDate is actually on the Account table in the database to keep this easy). How do I tell it to show only the top 10 accounts that are expiring within this table?

 

Every time I drag the date into the Top N "By value" filter box, it wants to count the dates rather than using that exact date value as the "by value" field.

1 ACCEPTED SOLUTION

Accepted Solutions
Vvelarde Super Contributor
Super Contributor

Re: How can I do a Top N by Date in a Table?

@Jaxidian

 

Please made a double check of this:

 

1. Do you have the latest version of PBI Desktop? If No, Please download the latest version of Power BI Desktop. January Update.

2. Your column Expiration Date is Date Type.?

 

 

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

4 REPLIES 4
Vvelarde Super Contributor
Super Contributor

Re: How can I do a Top N by Date in a Table?

hi @Jaxidian

 

Try with this TopN (Bottom)

 

TopN.png




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Jaxidian Regular Visitor
Regular Visitor

Re: How can I do a Top N by Date in a Table?

Hi @Vvelarde,

 

Thank you for that suggestion. I've tried that but the problem is that I cannot select "Earliest xxx" or "Latest xxx" (I assume that's the other option) because it's trying to aggregate my dates by counting them. You're somehow accomplishing something that I'm missing to get to your screenshot with "Earliest" as an option for the Dates.

 

 

pbitop.png

Vvelarde Super Contributor
Super Contributor

Re: How can I do a Top N by Date in a Table?

@Jaxidian

 

Please made a double check of this:

 

1. Do you have the latest version of PBI Desktop? If No, Please download the latest version of Power BI Desktop. January Update.

2. Your column Expiration Date is Date Type.?

 

 

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

Jaxidian Regular Visitor
Regular Visitor

Re: How can I do a Top N by Date in a Table?

@Vvelarde,

 

The data type is datetime but the update was the problem. I was still on the Nov release. Just installed the Jan release and the problem has been solved!

 

Thank you for the help!! :-)

 

-Shane

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 325 members 3,040 guests
Please welcome our newest community members: