Forum Discussion
Conditional formatting based on data rendered in a matrix
I am working with a matrix visualization to extract data from a single table. I would like to use conditional formatting to modify the color of the font based on the prior time periods cell value rendered in that matrix. I would like to simply show costs going up or down via red/green font. I see how this can be easily done if my if my dates values were in individual dedicated columns, but they are not. Any help would be appreciated.
Hi heathawalker, try this:
1.- Create this measure:
2.- Create this measure:
3.- Insert the second measure in Conditional Formating Values:The result is this:
I hope this can help you
2 Replies
Hi heathawalker, try this:
1.- Create this measure:
2.- Create this measure:
3.- Insert the second measure in Conditional Formating Values:The result is this:
I hope this can help you