how to organize 'others'

[Anonymous]

Hi Team,

Kindly see my data,

Name	Rank	#Price
Pepper	1	750
Juice	2	200
Pepsi	3	80
Cola	4	15
Bun	5

Here I just want to show the first 3 items based on the price and remaining all should be treated as 'Others'.The sample outout is following.

Name	Rank	#Price
Pepper	1	750
Juice	2	200
Pepsi	3	80
Others	4	15

Im having a direct query connection, so could not able to make it a by a measure or calculated column.Please help some one have the related experience.

Thanks in advcance! 

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my test, you could refer to below steps in query editor:

Add conditional column:

Apply it and create a table visual and you can see the result:

Regards,

Daniel He

[Stachu]

In order to display Others in rows you will need a row somewhere that actually says Others, e.g. with calculated table such as:

Names = UNION(VALUES('Table'[Name]),ROW("Name","Others"))

is that possible for you?

[Anonymous]

Hi @Stachu,

Thank you for the quick reply.

Is it a calculated table or column?

[Stachu]

you can use it in both, the example I posted was for a measure