Forum Discussion
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...
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!
Nathaniel_C
Community Champion
Community ChampionAnonymous ,
Here you go! You need to create a measure and use Format by field value.
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Color KPI = If (Max('Table'[Index] )= 2, "#b20000")