Forum Discussion

lordtopcat's avatar
lordtopcat
Icon for Helper I rankHelper I
6 years ago
Solved

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?     Latest version of PBI Desktop. Not sure what's going ...
  • AllisonKennedy's avatar
    6 years ago

    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