Forum Discussion
Matrix - conditional formatting when 3 values in a row are negative
Hi All! Unfortunately I am facing an issue and literally losing my mind trying to solve it. I have a matrix table and I want to conditional format it based on values that are for last 5 ISO weeks. I...
Hi Anonymous ,
Regardless the weeknum, you could create a measure to count the negative value for each row.
_count = CALCULATE(DISTINCTCOUNT('Table'[column]),FILTER(ALLSELECTED('Table'),'Table'[row]=SELECTEDVALUE('Table'[row])&&[Measure]<0))Then create the condition measure based the count value.
color = IF([Measure]<0&&[_count]>=3,"red")In your case, you could add weeknum condition to the first formula.
Best Regards,
Jay
Hi Anonymous ,
Regardless the weeknum, you could create a measure to count the negative value for each row.
_count = CALCULATE(DISTINCTCOUNT('Table'[column]),FILTER(ALLSELECTED('Table'),'Table'[row]=SELECTEDVALUE('Table'[row])&&[Measure]<0))Then create the condition measure based the count value.
color = IF([Measure]<0&&[_count]>=3,"red")
In your case, you could add weeknum condition to the first formula.
Best Regards,
Jay