3 Replies Latest reply on Sep 21, 2016 5:16 AM by ra.sae.0

    Formatting both background color and value color at the same time

    jenny.cherkasky

      Hi everyone,

       

      I have a table with many different measures and I would like to have a different background color for holidays which works fine. In addition to that, I would like my measure values to be black when  positive and red when negative. However, when I add my measure values to the color field, my background color disappears. Is there any way to differentiate both at the same time? When I change the default color of my values nothing happens.

       

      A little more explanation: I have formatted the background color using a calculated field which is 1 on weekdays and 0 on weekends. I have set the default value to min and added it to the colors. And I have a calculated field which is always 1, which I added to the size field.

       

      Thanks in advance!