Forum Discussion

tamara_nsb's avatar
tamara_nsb
Helper I
1 year ago
Solved

Apply formatting based on previous column value

    I need to change background on matrix fields if the "next" phase has a value.   I have data as shown,  each item has a score for 3 tests.  The tests are done 3 times,  once for each phase. ...
DAX
Formatting
  • lbendlin's avatar
    lbendlin
    1 year ago

    Please validate your test data.  I think a 3 and a 10 are switched (item1, A), and a 9 is missing from the expected output (item2, 3A)

     

    Why would item3, 1A and 1B be red when the 2A and 2B cells are empty?

     

     

tamara_nsb's avatar
tamara_nsb
Helper I
1 year ago

Thanks again for the explanation.     They want to fill left with red once there is any score in a higher phase.   So I do have to add that to the logic, thanks for pointing it out. 

I believe I understand now how to apply the logic.   the SELECTEDVALUE function was what I was missing.   I think I was way overcomplicting trying to add and remove filters.

 

Thanks

 

Thanks for your help!