Forum Discussion

nadanur's avatar
nadanur
Frequent Visitor
5 months ago
Solved

How to get the conditional formatting for missing combinations

Hello, I am new to Power BI and would really appreciate your help in solving this issue.   I am trying to add conditional formatting to the values in my matrix.   The problem is I am unable to g...
Need Help
  • danextian's avatar
    danextian
    5 months ago

    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.

     

danextian's avatar
danextian
Icon for Super User rankSuper User
5 months ago

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.

 

nadanur's avatar
nadanur
Frequent Visitor
4 months ago

Hi, This file was really helpful. However I am unable to get the similar results.

I have now created some dim tables for rows and columns and slicers. When i add this measure from fact table in value, it disrupts the matrix and shows all combinations irrespective of filter. However the same measure without "+0" works fine.

Zones Flag =
VAR _Cnt =
    SUM('Geographic Zones - Employees'[Value])+0
RETURN
_Cnt

 

 

 

Can you let me know whats wrong?