Forum Discussion
Color top 5 rows in a table
I was able to find the solution for this.
Solution:
Step 1: Create measure(M1)and use RANKX function to rank values in table based on column you want.
Step 2 : Create another measure M2 =IF(M1<=5,1,0)
Step 3 : Now in a table values,use conditional formatting based on M2
Hi nish2288,
Have you solved your problem by the solution provided by Greg_Deckler?
If you have solved, only thing that you'll have to notice, just always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please describe your scenario in more details and share your expected output, so that we can help further investigate on it?
Best Regards,
Cherry
I was able to find the solution for this.
Solution:
Step 1: Create measure(M1)and use RANKX function to rank values in table based on column you want.
Step 2 : Create another measure M2 =IF(M1<=5,1,0)
Step 3 : Now in a table values,use conditional formatting based on M2