cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
phamtrinh96 Frequent Visitor
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.

RestaurantNameTimeAmountDayTargetDay
232/3/20181200045000
232/3/20181254455654
322/3/2018140001255525
232/3/20182350085000
232/3/201845000125455
232/3/201898544556656
232/3/2018458222458222
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: [ Color top N ]

Hi @phamtrinh96 

Create measures

Measure = SUM(Sheet1[AmountDay])

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

set conditional formatting

1.png

 

 

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
Community Support Team

Re: [ Color top N ]

Hi @phamtrinh96 

Create measures

Measure = SUM(Sheet1[AmountDay])

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

set conditional formatting

1.png

 

 

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
Community Support Team

Re: [ Color top N ]

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.