Forum Discussion
Solved
Color top 5 rows in a table
Hi All, I have created table with 20 rows. I wanted to color first 5 rows only. Any idea?
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
With the May version you can base the color coding on a measure or other column. So, perhaps a RANKX measure but I would need to understand your data and how you are presenting it to be more specific.