Forum Discussion

gomezc73's avatar
gomezc73
Icon for Helper V rankHelper V
6 years ago
Solved

Format Grid

Hello guys,    I need help with this issue.   I have this table where an invoice is repeated x times depend how many product it has.      VENDOR Name Invoice# Amount Invoiced date Produ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi gomezc73 ,

     

    Through your thoughts, I thought of another good method which you could try.

     

    1.Create a calculated column sorted according to Invoice#.

    Rank = 
RANKX ( 'Table', [Invoice#],, ASC, DENSE )

     

    2.Create a measure value, if it is an odd number, it turns gray, otherwise it turns white.

    Measure = 
IF ( ISEVEN ( MAX ( 'Table'[Rank] ) ), "white", "grey" )

     

    3.Then follow the previous method to add the measure in Conditional formatting.

     

    4.The result is as follows.

     

    You can check more details from here.

     

     

    Best Regards,
    Stephen Tao

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