Forum Discussion

abpgupta's avatar
abpgupta
Icon for Continued Contributor rankContinued Contributor
5 years ago

Matrix: Conditional formatting on blank cells

Hi All,

 

Is there any way to apply conditional formatting in Matrix cells where there are no values for intersection? 

 

Currently based on rules, it just applies colors for non zero values.

 

Thanks for inputs!

 

 

5 Replies

  • yes when you applying a conditional formating theres a option to apply by a measure or value on that selected field, and another option to apply the format to blank values also. 

  • in your matrix measure values, create a "if" condition for a blank values and with values <> blank, create a varaibles with colors anda aply to condicional filed.
    measure =
    var blankvalues = "black"
    var nonblankvalues = "green"
    if(
    tableWithValues <> Blank,
    nonblankvalues,
    blankvalues,
    )
    you can use this for more option in your condition, like, tableWithvalue >= 2, "red" etc...


  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi abpgupta,

    You need to confirm these blank parts have corresponded records in your table.
    If they mean these records not include in your table, you need to create a category table of the field which not include all values and uses them on your matrix.
    Then you can write a measure formula to check the current category and look up raw table records and return specific results for conditional formatting.

    Regards,
    Xiaoxin Sheng

    • abpgupta's avatar
      abpgupta
      Icon for Continued Contributor rankContinued Contributor

      Thanks Anonymous!  Yes, there is no data for some combination of dimensions and they appear without formatting. Can you please provide a sample about above solution you suggested?