Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matrix conditional formatting if value is lower then previous year then red

Hey guys, I have a matrix which displays  count of shipments per month for 2018 and 2019 so for example the row for june will contain 2 numbers that of 2018 and 2019.   Now if the count of shipmen...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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 result
    Extra credit to MFelix  for all the help provided!
MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    This is the same type of information I made my mockup, and it worked, can you share a sample of your file trough private message? With data from both year to check what can be happening?

     

    Regards,

    MFelix