Forum Discussion
Display only top 5 rows when using a table visual
Hi, how to display only top 5 rows when using a table visual Requirement: Need to Display top 5 by Company&Cat&Country, so i can not use Top 5 from the filter panel, which only looks at one column(...
Not understanding rank for cardinality. Are you saying that you want the top 10 for each what? Please provide an example of expected output from the example data provided.
Hi, how to display only top 5 rows when using a table visual
Requirement: Need to Display top 5 by Company&Cat&Country, so i can not use Top 5 from the filter panel, which only looks at one column(Company or Cat or Country). how can i do this.
| Row | Company | cat | country | sales |
| 1 | Apple | CAT 1 | India | 600 |
| 2 | Amazon | CAT 2 | USA | 550 |
| 3 | Redhat | CAT 1 | CANADA | 500 |
| 4 | Microsoft | CAT 3 | CHINA | 450 |
| 5 | Uber | CAT 1 | UAE | 400 |
| 6 | Kaiser | CAT 1 | CANADA | 350 |
| 7 | AT&T | CAT 2 | UAE | 300 |
| 8 | Redhat | CAT 4 | VA | 250 |
| 9 | Microsoft | CAT 5 | USA | 200 |
| 10 | Uber | CAT 6 | UAE | 150 |
| 11 | Kaiser | CAT 1 | CANADA | 100 |
| 12 | AT&T | CAT 1 | India | 50 |
| 13 | AT&T | CAT 2 | CANADA | 30 |
| 14 | Uber | CAT 2 | CANADA | 20 |
try this
Rank Measure = RANKX ( summerize (table, table[company], table[cat]
table[couNTRY]
), [Sales measure], , DESC, DENSE )Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.