Format Grid

[gomezc73]

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	Product	cant	Unit	Amount
101012	Triple AA	20200012	50	8/15/2020	Toilet Paper	10	Box	15
101012	Triple AA	20200012	50	8/15/2020	Liquid Soap	15	Box	10
101012	Triple AA	20200012	50	8/15/2020	Toothpaste	12	Box	25
101012	Triple AA	20200018	23	8/15/2020	Water with gas	5	Box	8
101012	Triple AA	20200018	23	8/15/2020	Pepsi 2ltr	10	Box	15
311232	AH Services	20200022	10	8/15/2020	Bath repair	1	Srv	10
311232	AH Services	20200025	80	8/15/2020	Clean services offices	1	Srv	50
311232	AH Services	20200025	80	8/15/2020	Clean services outside	1	Srv	30

Is possible give alternating format  by invoice?.

By Example, the first three lines has invoice#20200012, then I would like these lines with background Gray.

The following two lines has invoice#20200018, then these two lines with without background.

Line 6 has invoice#20200022, then repeat the format with background Gray.. etc..

Thanks in advance

[v-stephen-msft]

Hi @gomezc73 ,

You can create a measure and use the new 'Conditional Formating' option where you select Format by 'Field Value' and in this you choose the measure shown below.

You do this for every column.

Measure = 
    IF( SUM('Table'[Invoice#]) =20200012 || SUM('Table'[Invoice#])=20200022
        ,"grey"
        ,"white"
    )
 

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.

[gomezc73]

Hi, thank for the response, it could be a solution but with the real data i can't ask by the invoice# dur i don't know it,

Do you think if this solution could have a variation if I can have in a measure the PRIOR_INVOICE_READ, so the background will be Grey if the invoice read is the same, when it change then backgrud will be white..?.. It is possible? 

Measure =
IF( SUM('Table'[Invoice#]) =PRIOR_INVOICE_READ
,"grey"
,"white"
)

[v-stephen-msft · Accepted solution]

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.

[amitchandak]

@gomezc73 , I doubt that is possible. Try matrix with stepped layout off

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/