Forum Discussion

SteWilf's avatar
SteWilf
Regular Visitor
2 years ago
Solved

Conditional Formatting Matrix Based on Date Comparisons

Hi,    I hope everyone is well, and hoping someone can help solve a problem a few of us have been trying to solve and so far been unable. We've spent a lot of time on this, used many articles from ...
Need Help
  • SteWilf's avatar
    SteWilf
    2 years ago

     To close the loop on this, I was able to solve the problem through the use of several measures and a complete redesign of the data model.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi SteWilf ,

I opened the .pbix file and find that you can change the CF Test codes.

You can change the IF ([CellCount] = 0,"Blue", it makes all the zeros blue, which is not satisfying your needs, so I think you can make changes.

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • SteWilf's avatar
    SteWilf
    Regular Visitor
    2 years ago

    Hi Anonymous 

     

    Thank you for taking a look at the files and sharing feedback.

     

    The IF ([CellCount]) = 0, "Blue" is as close as we have been able to get to the requirement, this is where we are struggling to solve the problem because we can't find a way to compare the position of that 0 value in the matrix to the dates of relevance. i.e.  if the zero count is in the August column, we need to be able to say is August greater than, less than or equal to the Contain Date and/Resolution Resolution Date for the row, but so far have been unable to find a way to do this. 

     

    Are you aware of any way this can be done? 

     

    Thank you

    Steve