cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Top 5 displaying all results?

Hi,

 

What am I doing wrong? I want to display the top 5 Timeline ID's by latest packdatetime. What have I missed to make it work?

 

pbitop.png

 

Latest version of PBI Desktop. Not sure what's going on...

 

Cheers

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

This is because you are filtering the TimelineID not the PackDateTime. Try changing the PackDateTime on your table to 'latest PackDateTime' (click the down arrow next to PackDateTime in the fields pane for the visual) and that should demonstrate a bit better what's actually happening with this filter. 

 

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

 

If you found this post helpful, please give Kudos.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

https://sites.google.com/site/allisonkennedycv

 


______________


Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 


If you found this post helpful, please give Kudos.


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


excelwithallison.com

View solution in original post

4 REPLIES 4
Highlighted
Super User II
Super User II

This is because you are filtering the TimelineID not the PackDateTime. Try changing the PackDateTime on your table to 'latest PackDateTime' (click the down arrow next to PackDateTime in the fields pane for the visual) and that should demonstrate a bit better what's actually happening with this filter. 

 

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

 

If you found this post helpful, please give Kudos.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

https://sites.google.com/site/allisonkennedycv

 


______________


Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 


If you found this post helpful, please give Kudos.


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


excelwithallison.com

View solution in original post

Highlighted
Super User IV
Super User IV

@lordtopcat , What I doubt Typically visual filter of Top N is a measure filter. So better you create a rank on the date and use that.

 

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

 

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

Hi @lordtopcat ,

 

Does your two columns from one table or two tables?

 

Based on my test, If the two columns from different table and the relationship between time table and fact table is one to many, the filter value in TimelineID, it can show the result that you have shared.

 

TOP 1.jpg

 

We can solve this issue by following way:

 

Put the [PackdateTime] that is the same table with [timelineID] in filter value.

 

TOP 2.jpg

 

If it doesn’t meet your requirement, Could you please provide a mockup sample  based on fake data or describe the fields of each tables and the relations between tables simply?

 

BTW, pbix as attached.

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Community Support
Community Support

Hi @lordtopcat ,

 

How about the result after you follow the suggestions mentioned in my original post?
Could you please provide more details or expected result about it If it doesn't meet your requirement?

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors