Highlight significant changes to previous month in matrix visual

[bkr]

Hi, is it possible to highlight changes above e.g. 10% vs. the preceding month in a matrix visual?

The result is expected to look like this:

	January	February	March	April
Sales	10000	10500	9000	10000
variable costs	3000	3150	2500	2700
fixed costs	1000	1000	1000	1150
overhead costs	500	1200	500	500
EBIT	5500	5150	5000	5400

Thanks!

[bkr]

All numbers are in a single column and I have an attribute column ("line items")

[olgad · Accepted solution]

Then,  use Sum(Amount)   instead of YOURMEASURE

[bkr]

Thanks, Olga!

yet I don't get it yet. What is [yourmeasure]?  It doesn't seem like calculate accepts a column as first argument.

My data has the following columns:

Table Facts:

[Line item]: Sales, variable costs, fixed costs, overhead costs

[Amount]: numbers listed above

[calendar]: Year and month

[EBIT]: is a calculated column

[olgad]

Sum(Amount) is your measure, your numbers ,what you are displaying.

line items, what do you mean, those are the values in a column? or those are separate columns?

[olgad]

Format  Measure =

var PrevMonth=Calculate([YOURMEASURE], DATEADD('Calendar'[Date],-1,MONTH))

RETURN

If(DIVIDE([YOURMEASURE]-PrevMonth, PrevMonth)>0.1, 1,
If(DIVIDE([YOURMEAASURE]-PrevMonth, PrevMonth)<-0.1, 1,
0)

)