I did the following in master measure and in color background expression. now the "missing" can be showed up in the table, but cannot be colored in background. however if to use a different expression in background color, we can see the color change only on value with date, instead of filed with "missing", i don't know why?
the strange thing was, I did some time ago with assigning "0" to empty cell and color background successfully, I don't know the failure reason behind here? can someone advise?
Hello Ivan, but you saw my previous post yesterday in the same way as you did, with the source data from qvd file, it didn't return the desired color. so because of system surrounding context different? or what could be the reason？