How to do conditional formatting on calculated measures?

[pborah]

I have 2 calculated measures - 

%change from last year and % change from two years ago. These are calculated measures that are in the "values" card for a bar chart. I'm unable to find the conditional formatting option for these two measures. Please help. Thanks.

 

[Anonymous · Accepted solution]

Hello, try checking the Data Colors format options.

1. With your visual selected, click format options in the visualizations pane:
   
2. Scroll down to Data Colors and expand it. You should see a color selector as well as a Fx button that lets you add conditional formatting.
3. In my brief tests, I've noticed if you have no Axis assigned, this Fx option doesn't appear. Try putting in a dummy field that all records share so there's only one bar and it should show up.

[pborah]

That worked! Thanks!