topic Display only top 5 rows when using a table visual in DAX Commands and Tips

Display only top 5 rows when using a table visual

yjetti_gps — Sat, 18 Jan 2020 00:16:12 GMT

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

Re: Display only top 5 rows when using a table visual

Greg_Deckler — Thu, 16 Jan 2020 19:40:57 GMT

Go into your Filtering pane and use a TopN filter

Re: Display only top 5 rows when using a table visual

yjetti_gps — Thu, 16 Jan 2020 20:13:51 GMT

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

Re: Display only top 5 rows when using a table visual

Greg_Deckler — Thu, 16 Jan 2020 21:55:03 GMT

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.

Re: Display only top 5 rows when using a table visual

yjetti_gps — Sat, 18 Jan 2020 00:16:55 GMT

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

Re: Display only top 5 rows when using a table visual

Anonymous — Wed, 22 Jan 2020 09:08:58 GMT

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.