Forum Discussion
Matrix conditional formatting if value is lower then previous year then red
Managed to fix it by instead of count using sum in the formale since my table already"counts" the values.
Condittional formatting =SWITCH (TRUE (),SUM('Export'[COUNT] )< CALCULATE (SUM('Export'[COUNT] ),SAMEPERIODLASTYEAR ( DateTable[Date])), "#ff8800")final resultExtra credit to MFelix for all the help provided!
Hi MFelix
Nah I tried that doesn't make a difference for the result. I'm not sure what makes the higher values appear orange, it seems pretty random but it might be something in the dataset. I will have a look at it, but any suggestions?
EDIT: forgot to mention shipment_date is date/time so for example 24/07/2018 00:00:00 can this cause issues creating a relationship with a date table? That would seem the only obvious explanation. checked changed to date no changes
Super UserHi Anonymous ,
Sorry for the question but your calendar table is starting on January 1st and ending on December 31st (can be different years)correct?
Regards,
MFelix
Yes it starts at 01-01-2018 ends at 31-12-2019
- MFelix
Hi Anonymous ,
Based on my experiences should work as expected, can you share a sample of your data?
If it's sensitive data you can send a mockup or send it trough private message.
Regards,
MFelix
This is a sample of my query with the shipment_date changed to date instead of date/time dont think it matters though. hopefully this helps.