Create graph based on specific Top N counts

Shimmerz

New Member
Joined
Jun 7, 2019
Messages
1
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.

January

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

February

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

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,099,987
Messages
5,471,830
Members
406,788
Latest member
cmtjack

This Week's Hot Topics

Top