I imported an excel table (column 1: month, column 2: sales) and wanted to know if there was a way to conditional color based on the previous month's sales figure (for example: if previous month sales is less than current month sales, green, otherwise red).
I'm using:
sum({<Month={'$(=max(Month))'}>} [Sales])
to reference the most recent month's sales entry to display in the KPI, and wanted to display the metric red or green based on previous month.