Format field conditionally if no data 6 months in a row

[Anonymous]

Hello,

I've a question: is it possible conditional formatting in table? Let's say I've table and I want format field in red if there are no data 6 months in a row. So in below table I wish June to be red because it's 6th month in a row that there no data in table for specific customer.

Thank in advance!

[Greg_Deckler · Accepted solution]

Yes, I would create a separate measure that returns 1 for this case and 0 otherwise (or whatever values you prefer) and then you can use this measure for conditional formatting.