New to Power BI and trying to figure a way to generate graphs based on specific Top N (other than top 1) count conditions without adjusting filters. The idea would be to have it auto update based on new data each month without having to manually select filters.

Example using meal choices out of Table 1 and a Count of Items for No Sold.


Rank. Item No sold
1. Hamburger 30
2. Pizza 21
3. Salad. 15


Rank. Item. No sold
1. Chicken. 27
2. Salad. 21
3. Pizza. 18