Table Conditional Formatting based on Values

[PaulBethancourt]

I'm looking for a way to format the background colors based on a break of Fake Invoice #'s.  I just  need the first row colored, like the example below.  I don't knnow if this is even possible.

[Anonymous · Accepted solution]

Hi @PaulBethancourt 

You can try the following steps:

1. Add an index column to a table in the Power Query.

If the index column is not added, the effect in the table visualization is shown below.

2. Create several measures as follow:

Measure = 
    VAR _t = ADDCOLUMNS('Table', "Group", RANKX(ALL('Table'), [Fake Invoice #], [Fake Invoice #], ASC, Dense))
RETURN 
    SUMX(_t,[Group])

formatting = IF(ISODD([Measure]), "yellow", "green")

3. Make the Conditional Formatting settings as shown here.

Is this the result you expect?

Best Regards,
Community Support Team _Yuliax

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulBethancourt]

Excellent solution!  Thank you.

[Dangar332]

hi, @PaulBethancourt 

not a conditional formatting but it may help you