[ Color top N ]

[phamtrinh96]

Hello, I have a table, There are 4 columns, RestaurantName, Time, AmountDay, TargetDay. I need to sort the AmountDay and color in the top 3. But I have a slicer select time, so each time I choose, the table will have different results. So every result I need is color top 3.  I need solution with this problem. Thanks you.

RestaurantName	Time	AmountDay	TargetDay
23	2/3/2018	12000	45000
23	2/3/2018	12544	55654
32	2/3/2018	14000	1255525
23	2/3/2018	23500	85000
23	2/3/2018	45000	125455
23	2/3/2018	98544	556656
23	2/3/2018	458222	458222

[v-juanli-msft]

Hi @phamtrinh96 

Is this problem sloved?

If not, please let me know.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft · Accepted solution]

Hi @phamtrinh96 

Create measures

Measure = SUM(Sheet1[AmountDay])

Measure 2 = RANKX(ALLSELECTED(Sheet1),[Measure],,DESC,Dense)

set conditional formatting

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.