Forum Discussion
pborah
Solution Sage
Solution SageHow 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 conditi...
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:
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.
pborahSolution Sage
Solution SageThat worked! Thanks!