Forum Discussion
Helper VFormat 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 | 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
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 TaoIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- amitchandak
Super User
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/
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.
gomezc73Hi, 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"
)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 TaoIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
