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:

 JanuaryFebruaryMarchApril
Sales1000010500900010000
variable costs3000315025002700
fixed costs1000100010001150
overhead costs5001200500500
EBIT5500515050005400

 

Thanks!

Need Help
  • olgad's avatar
    olgad
    3 years ago

    Then,  use Sum(Amount)   instead of YOURMEASURE

5 Replies

  • 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)
    )
  • bkr's avatar
    bkr
    Icon for Helper I rankHelper I
    3 years ago

    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's avatar
      olgad
      Icon for Resident Rockstar rankResident Rockstar
      3 years ago

      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?

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

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

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

      Then,  use Sum(Amount)   instead of YOURMEASURE