cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Format field conditionally if no data 6 months in a row

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.

 

Capture1.PNG

 

Thank in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Format field conditionally if no data 6 months in a row

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


1 REPLY 1
Super User
Super User

Re: Format field conditionally if no data 6 months in a row

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!