Showing results for 
Search instead for 
Did you mean: 

conditional formatting based on multiple fields in Lumira Designer

0 Kudos

Hello Experts,

There are two Column( Start Date and Finish Date) in my Crosstab. Our User wants to highlight/format the cells of these columns based on below conditions :

-if both Dates are available then GREEN

-if Start Date is available and Finish Date is not then GREY

-if both Dates are unavailable then YELLOW

This is easily achievable in webi but don't know how to implement this in Lumira Designer.

We are using Lumira 2.1 version.

Thanks in Advance!

Accepted Solutions (0)

Answers (2)

Answers (2)

Active Contributor
0 Kudos

Maybe you could create a calculated measure and set you conditional formatting on that?

Active Contributor
0 Kudos

Hello - have you tried the steps as outlines in this Visual BI blog:

0 Kudos

Hi Tammy,

Thanks for the quick response.

I already looked to this blog. This is not helpful as it talks about how to implement the conditional format in Lumira Designer in general. I already know how to implement the conditional format in Designer.

In our scenario we have to create a formatting Rule based on two fields( AND condition)

The challenge as you can see in above screenshot is that we cannot create a AND condition here.