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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,099,257
Messages
5,467,613
Members
406,544
Latest member
Aditya_Shanmugham

This Week's Hot Topics

Top