'Dynamic Top N multiple column

Ive got data in power BI pulled from SQL. Columns are : Date, SiteName, PersonName, SalesNumber,

What I want to do is to have a table to show the Date and then in that show the top 5 PersonName and the Sales Number. Each day will show the different peoples name and the volume. I need it to be dynamic so that If i then select a specific site it will pull the top 5 from that specific site. Example Outcome



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source