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

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Watch MrExcel Video

Forum statistics

Threads
1,099,861
Messages
5,471,171
Members
406,747
Latest member
smstrickland

This Week's Hot Topics

Top