Conditional Formatting - table MoM

SamanthaC

Hello,
I'm trying to set color rules/conditional formatting in a table card. What I'd like to do is set rules that if that months sales figure is higher than the previous it'll be green, if that months sales figures is lower than the previous it'll be red. (ex. If July sold 10, but Aug sold 8 August's value would show as red since there was a drop off) Photo attached of the table's current header set up:

The color rule conditions don't seem to be able to compare to other values in the table so I assume I need a beast mode I'm just not sure how to go about it.

DavidChurchman

You can't directly.

• You could change your measure to be "change from prior month" instead of the raw value.
• You could have that "change from prior month" as a separate value in the pivot table, and color-code that
• A different approach I've used is concatenating an icon in the formula. I showed a (not particularly attractive) example in this post, though the formula you'll need in your case will be a bit harder:

https://community-forums.domo.com/main/discussion/67883/pivot-table-coloring

• Here's another example I posted that I think looks a little nicer:

https://community-forums.domo.com/main/discussion/comment/95482#Comment_95482

DavidChurchman

You can't directly.

• You could change your measure to be "change from prior month" instead of the raw value.
• You could have that "change from prior month" as a separate value in the pivot table, and color-code that
• A different approach I've used is concatenating an icon in the formula. I showed a (not particularly attractive) example in this post, though the formula you'll need in your case will be a bit harder:

https://community-forums.domo.com/main/discussion/67883/pivot-table-coloring

• Here's another example I posted that I think looks a little nicer:

https://community-forums.domo.com/main/discussion/comment/95482#Comment_95482