Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am trying to color code my pivot table. The value are ranging from -1 to 1. i try to make the data above 0 in Green and below 0 in red. And the same time, the color is also value associated.
the current expression i use is:
ColorMix2(Sum({$<country_cde={"us"}>}[pivot_data.value])/before(Sum({$<country_cde={"us"}>}[pivot_data.value]))-1,RGB(128,0,0),rgb(0,100,0))
but the color is showed is below:
any suggestion?'
Thanks,
Nathan
Do you have a sample app or sample data we could tweak - so you get some suggestions quicker?
... no .. and i could not share the original data. sorry about that.