Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Conditional Formatting based on other measure value no effect when blank

 I have a Matrix , I amusing the  condional Formating the Colors of the Values using a Field value  ...  .. which works .. But when there is no value for the Category ...  it defaults to White ... is...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    ElenaN 

    oldway

    COUNT(SuccessionPlanning[Employee Name])

     

    Newway

    count(SuccessionPlanning[Employee Name]) +0 

    I know it is weird ..
     
    I started researching how to delete with Blank in Dax .. but nothing looks simple@Elena
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    To update the measure as below should work well.

     

    measure = var a = count(SuccessionPlanning[Employee Name])
return
IF(ISBLANK(a),0,a)
ElenaN's avatar
ElenaN
Resolver V
7 years ago

Hello,

 

I don't know how the measure used in the report is defined, but an idea could be to add 0 to your calculation (e.g. 'Measure  = SUM(Amount) + 0' ). That way if you don't have values it will still show 0 and you can color code the value 0.

 

Regards,

ElenaN

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    ElenaN 

     

    Just tried that , did nothing ... I am doing a simple count(EmployeeName)   But the Employee will l be only in one column ... there are 6 possible choices ...   that is why it is tricky ...

    On the tool tip it shows the value [BLANK]   but it would not take the + 0

    • ElenaN's avatar
      ElenaN
      Resolver V
      7 years ago

      So, you changed your measure from 'count(EmployeeName) ' to 'count(EmployeeName) + 0' and still does not show 0 in your matrix? 

       

      Regards,

      ElenaN

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        ElenaN 

        oldway

        COUNT(SuccessionPlanning[Employee Name])

         

        Newway

        count(SuccessionPlanning[Employee Name]) +0 

        I know it is weird ..
         
        I started researching how to delete with Blank in Dax .. but nothing looks simple@Elena