Forum Discussion
Conditional Formatting showing wrong colors based on drop down filter
Friends, Need help for conditional formatting. I have attendance data for employees. If Present (Yes) - GREEN, Absent (No) - RED and No data for a date - YELLOW. Yellow is conditoned like if blan...
amitchandak
Super User
Super UserAnonymous , can you share your measure/values of matrix and conditional formatting calculation
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?