Conditional Formatting based on other measure value no effect when blank

[Anonymous]

 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 there any way to show a zero on the Matrix if there is No Values for the Column ... and then it will use the color formatting for that column ...

The user would like to see zeroes, I have tried putting the measure in the value column ...  or just a count of a Field but since there are no records that match ..   

 the first line , and third line should be color coded and if possible display a zero ... 

Thanks for any assistance ...

[Anonymous · Accepted solution]

@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

[ElenaN]

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]

@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]

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

Regards,

ElenaN

[Anonymous · Accepted solution]

@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 · Accepted solution]

Hi @Anonymous ,

To update the measure as below should work well.

measure = var a = count(SuccessionPlanning[Employee Name])
return
IF(ISBLANK(a),0,a)

[Anonymous]

@v-frfei-msft 

This worked great for the Card Visuals ... But for some reason , the Default Matrix Visual still does not like it ..    it is just weird ...  and that is the best visual to show this data ...

I looked at my other Matrix visual , that is using  the same logic and it now displays the zero ... Noticed that the Column Values are coming from a Valid Table of Values ...  I was deriving from the data ..

Thanks the solution works ... when I use a Reference Table for the Columns ...  If it only comes from the data , it seems to have a problem .. 

Thanks