CODEWITHSUNDEEP
reportpowerbidashboard
xavier
xavier

Reputation: 177

Top N Sort in Power BI

I am creating a report in Power BI and I want to present the data from a column sorted by another column. Multi-row Card is the best visualisation that can show the text of that first column that I was writing about.

I have tried to filter the shown data by using Top N option. Top N by value (value that was the column that I want to be taken into consideration when presenting the data from the first column)

I want the list to be presented in the following order :

Milo Can
Milo Regular
Nescafe 3 In 1
Milo 3 In 1
Nescafe 2 In 1
Nescafe RTD
Milo 3 in 1
Nestea
Milo UHT Breakfast

as this is the ranking based on the other column :

731    Milo Can
1837   Milo Regular
2943   Nescafe 3 In 1
4049   Milo 3 In 1
5155   Nescafe 2 In 1
6261   Nescafe RTD
7367   Milo 3 in 1
8473   Nestea
9579   Milo UHT Breakfast

Can someone please help me with that? Thanks

Upvotes: 0

Views: 1905

Answers (1)

Aldert
Aldert

Reputation: 4313

See example below: Add the title to the values of the grid. Now go to the Filters and select Top N (not Basic). give the numbers of items you want to show and set as By value the rank field. Do not forget to apply the filter.

enter image description here

Upvotes: 1

Related Questions