Question

You build a matrix that shows each store's monthly revenue. Management wants a visual status indicator next to each revenue value: a green up-arrow when revenue meets or exceeds a target measure [Target], a yellow dash when it is within 10% below target, and a red down-arrow when it is more than 10% below target. You must implement this without adding extra columns to the table and without a separate visual. What should you do?

Accepted Answer

Apply conditional formatting Icons to the revenue field, using rules based on a measure that returns the ratio of revenue to [Target].

Answer

Add a KPI visual next to the matrix and set the target to [Target] with a good/neutral/bad color range.

Answer

Apply conditional formatting Background color to the revenue field with three color rules comparing revenue to [Target].

Answer

Create three separate measures returning arrow emoji text and place them in adjacent matrix value fields.