Display only top 5 rows when using a table visual

[yjetti_gps]

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

[Greg_Deckler]

Go into your Filtering pane and use a TopN filter

[yjetti_gps]

that will only give me top ten only for that coloum, but need the rank for  cardinality

[Greg_Deckler]

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.

[yjetti_gps]

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

[Anonymous]

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.