Forum Discussion
Solved
How to do conditional formatting on calculated measures?
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.
Hello, try checking the Data Colors format options.
- With your visual selected, click format options in the visualizations pane:
- 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.
- 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.
- With your visual selected, click format options in the visualizations pane:
2 Replies
Hello, try checking the Data Colors format options.
- With your visual selected, click format options in the visualizations pane:
- 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.
- 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.
That worked! Thanks!
- With your visual selected, click format options in the visualizations pane:
