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(...
Go into your Filtering pane and use a TopN filter
that will only give me top ten only for that coloum, but need the rank for cardinality
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.