Color top 5 rows in a table

[nish2288]

Hi All,

I have created table with 20 rows.

I wanted to color first 5 rows only.

Any idea?

[v-piga-msft]

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

[nish2288 · Accepted solution]

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

[Greg_Deckler]

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.