Conditional formatting for one column where variances exceed +/-$150K
2 Antworten
I'm going to take a wild stab - on the [Measure Values] pill on your Marks card, click on it and select "Use Separate Legends". Change every column except the one you want to format to be a 2 step colour range from black to black (or your choice of default font colour). For the column you want to format, select a 2 step range with 150K as the central value and choose colours for the values above and below that.