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(...
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.