cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## [ Color top N ]

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
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: [ Color top N ]

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.

2 REPLIES 2
Community Support Team

## Re: [ Color top N ]

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.

Community Support Team

## Re: [ Color top N ]

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.