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
Some update: I have managed to write the DAX function:
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