Forum Discussion
Conditional Formatting on Matrix - Comparing Values per Previous Month
- 4 years ago
Hi, Mitchell92
The dates in your original table are not consecutive, you need to create Measure 'color condition' based on a calendar table.
Please add a calendar table, replace the date fields with those in calendar table, and change ‘color condition’ as follows:
Color condition: = VAR _currentmonth = [Values total:] VAR _previousmonth = CALCULATE ( [Values total:], PREVIOUSMONTH('Calendar Table'[Date]) ) RETURN IF ( SELECTEDVALUE ( Sheet1[Date] ) = 1, "Black", IF ( _currentmonth < _previousmonth, "Green", "Red" ) )Best Regards,
Community Support Team _ Eason
Hello,
Sorry for the delay, please shared find link below:
https://app.box.com/s/9xt6zosqylkq9mj71rtt8fdysfcz4bt1
Thanks,
Mitch
Hi, Mitchell92
The dates in your original table are not consecutive, you need to create Measure 'color condition' based on a calendar table.
Please add a calendar table, replace the date fields with those in calendar table, and change ‘color condition’ as follows:
Color condition: =
VAR _currentmonth = [Values total:]
VAR _previousmonth =
CALCULATE (
[Values total:],
PREVIOUSMONTH('Calendar Table'[Date])
)
RETURN
IF (
SELECTEDVALUE ( Sheet1[Date] ) = 1,
"Black",
IF ( _currentmonth < _previousmonth, "Green", "Red"
)
)
Best Regards,
Community Support Team _ Eason
- Mitchell924 years ago
Helper II
This is perfect, thank you so much for your support and patience!