Forum Discussion

MKPartner's avatar
MKPartner
Helper II
10 months ago
Solved

Conditional formating - comparing day to day

Hello, 

 

I have data downloaded daily which are filtered by days in table '12week_plan'[Data]. I have a table with columns where I'd like to implement conditional formating of each row to indicate changes of value like decreased, increaased or it's equal against previous day. 

 

 

I'm using below DAX to get it: 

 

CF_Act_WK = 

    VAR ACT_DAY = CALCULATE('12week_plan'[Act_WK],
                                FILTER('12week_plan','12week_plan'[Data]))
    VAR PREV_DAY = CALCULATE('12week_plan'[Act_WK],
                                FILTER('12week_plan','12week_plan'[Data]-1))

RETURN
SWITCH(True(),
                    ACT_DAY - PREV_DAY < 0,"ColoredArrowDown",
                    ACT_DAY - PREV_DAY = 0,"ColoredArrowRight",
                                        "ColoredArrowUP")

 

My issue is that when I changing dates filter, I can always see "ColoredArrowRight" mark evan values are decreasing or increasing. 

 

Thanks for support. 

Need Help
  • mh2587's avatar
    mh2587
    10 months ago
    _test = // Try this might help you
VAR CurrentDate = SELECTEDVALUE('12week_plan'[Data])
VAR PrevDate =
    CALCULATE(
        MAX('12week_plan'[Data]),
        FILTER(
            ALL('12week_plan'),
            '12week_plan'[Data] < CurrentDate
        )
    )
VAR CurrentValue = CALCULATE(SUM('12week_plan'[Act_WK]))
VAR PrevValue = CALCULATE(SUM('12week_plan'[Act_WK]), '12week_plan'[Data] = PrevDate)
RETURN
SWITCH(
    TRUE(),
    CurrentValue > PrevValue, "ColoredArrowUp",
    CurrentValue < PrevValue, "ColoredArrowDown",
    "ColoredArrowRight"
)

1 Reply

  • mh2587's avatar
    mh2587
    Super User
    10 months ago
    _test = // Try this might help you
VAR CurrentDate = SELECTEDVALUE('12week_plan'[Data])
VAR PrevDate =
    CALCULATE(
        MAX('12week_plan'[Data]),
        FILTER(
            ALL('12week_plan'),
            '12week_plan'[Data] < CurrentDate
        )
    )
VAR CurrentValue = CALCULATE(SUM('12week_plan'[Act_WK]))
VAR PrevValue = CALCULATE(SUM('12week_plan'[Act_WK]), '12week_plan'[Data] = PrevDate)
RETURN
SWITCH(
    TRUE(),
    CurrentValue > PrevValue, "ColoredArrowUp",
    CurrentValue < PrevValue, "ColoredArrowDown",
    "ColoredArrowRight"
)