Forum Discussion
How to get the conditional formatting for missing combinations
Hi nadanur
Power BI cannot apply values - to records that do not exist or to blank entries. A possible workaround is to use separate dimension tables for both row and column categories and assign a value within a measure (usually a zero) when blanks are returned. However, this introduces another issue: it may display values in row/column intersections that should not exist under the current filter context.
Please see the attached pbix.
Create a copy of measure as testmeasure.
Try to add this test measure into the matrix and see what it gets displayed. if it is working per your needs, then go to this next step.
Could you try changing this line of code as red or to the desired color you need? See if it works!
if it does not work, try to change the testmeasure to display the values in your calculation: _ZoneCount, then try with _Division, then with _MergedColumn, _DivisionPrefix, _MergedSuffix.
Goal is to identify where the measure is not behaving correctly
this way you know what exactly it is going on and then do the fix.