Forum Discussion

bkr's avatar
bkr
Icon for Helper I rankHelper I
3 years ago
Solved

Highlight significant changes to previous month in matrix visual

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 ...
Need Help
  • olgad's avatar
    olgad
    3 years ago

    Then,  use Sum(Amount)   instead of YOURMEASURE

olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
3 years ago

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)
)