Greetings everyone,
I am trying to colour code the "Prev Week Var" column in attached twbx as Red or Green depending on the negative or positive value. If i apply a calculated field "all columns" are being coloured. Can anyone please point me to a way in which I can only colour the values in that column. Thank You.
The Variance values are hard coded for this pilot and not a Actual - Budget value.
got it.
drag measure values into the color.
edit colors to custom diverging
check stepped color = 2 steps (red on left green on left)
check advanced.
select start , end, and Center is 0.
when i edited yours start shows -977 to 977 on the color bar however in the advanced settings start is -0.192982456 end is 977 and center still at 0.
hope this helps.
it still will probably put the prev week and etc. in red if the values are negative but if you do the exact same thing on just Prev Week Var in the color it should work.
also fyi i pulled "publication" pill down in Rows leaving Measure names only in columns...not that it mattered. but just fyi.
