Forum Discussion
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 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 ...
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@ElenaHi Anonymous ,
To update the measure as below should work well.
measure = var a = count(SuccessionPlanning[Employee Name]) return IF(ISBLANK(a),0,a)
6 Replies
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
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
So, you changed your measure from 'count(EmployeeName) ' to 'count(EmployeeName) + 0' and still does not show 0 in your matrix?
Regards,
ElenaN
