Forum Discussion
Dax function for conditional formatting cells in matrix
Hi Anonymous,
>>How do I modify the DAX function such that if the cell is blank (i.e., does not have any value), the cell background will be grey?
You need to confirm these blank cells are really include in your table instead of expanded by category fields, the conditional formatting feature should not works on not existed records.
For this scenario, you need to use unconnected tables with current category types as row and column axis, then you can write measure formula to use current row context to lookup raw table records. After these steps, you can do conditions formatting on this visual blank parts.
Regards,
Xiaoxin Sheng
I forgot to add that, there are two instances where it uses an inverse scale (i.e., Non- Energy Cash Cost and LOC Incidents), in that case the rules will be the opposite of the ones mentioned above, where it has to be less than "Stretch" to be green and greater than "Threshold" to be red. Not sure how do I go about modifying the DAX function.....