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!
Anonymous's avatar
Anonymous
Not applicable
5 years ago

MFelix for some reason Power BI is not allowing me to post it here nor am I able to send you a private message. Please advise

MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi Anonymous

 

To share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    MFelix its not allowing me to post any link or file for some reason (saying post flooding detected). Can I email you somewhere?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    MFelix Thank you, I have sent you the email