Initially, the conditional formatting was functioning correctly, displaying a green “+” if the metric was greater than 0 and a red “-” if the metric was below 0. However, I had to incorporate an additional metric in the parameter using a sumover, resulting in additional hidden rows and columns. After this addition, the conditional formatting ceased to work. Is there a workaround for this issue?
Hi @Phillip_Le
could pls you share you definition of the conditional formatting as well?
BR
Oh I am using the default “conditional formatting” from the “Format Visual”
But what did you define? Can you share a screenshot?
@ErikG Any initial thoughts?
Hi @Phillip_Le
is the formatting working on row level?
BR
No. There is no color @ErikG
Hi @Phillip_Le ,
I cross checked pivot conditional formatting and it is working as expected at my end.
From the attached screen shot, I see that the formatting you applied is based on a calculated field.
Most likely, the calculation value at cell level might be evaluating to null.
Try adding the calculation to the pivot display to check if this is the case, tweak the calculation to get the expected values and then remove from display.
Also, I see that the pivot has a marketplace field that is in collapsed state. Conditional formatting is applied only to detail row level cells and not to summaries. (Use above mentioned approach if you aren’t seeing conditional formatting on detail rows.)
If you are still blocked after trying the above steps, create a sample analysis in Arena showing your problem state and share the link here. (Read below linked article if you haven’t used Arena yet.)
Regards,
Arun Santhosh
Pr QuickSight SA.