Forum Discussion

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous ,Need to check file to find issue

 

Create a color measure

 

Switch(True(),
max(Table[Attendance]) ="Yes", "Green",
max(Table[Attendance]) ="No", "Red",
)

 

and use that in coditional formatting using "Field Value" option

Anonymous's avatar
Anonymous
Not applicable
5 years ago

But when I select No in the drop down filter the cells which is having Yes will become blank. I have a condition in conditional formatting like if blank then yellow. So the dates for green changes to yellow.

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , can you share your measure/values of matrix and conditional formatting calculation

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I used Submitted_Flag = IF(Submitted = "Yes",1,0) 

      Then used this for conditional formatting. Result is coming as expected. But when I select "NO" in the submitted drop down the table is showing NO but hiding YES. When YES is hidden due to this drop down selection PBI is treating it as BLANK and giving an amber  icon. How to overcome this?