Forum Discussion
Conditional Formatting of Blank Values in Matrix using DAX
Hi Anonymous ,
I tried to find other possible ways (conditional formatting Format style as Field value), but it failed... At the moment it seems to be possible to find a more feasible way which is the way you mentioned in your reply that the blank value will be treated as 0 when calculating the hours, and then the data with "blank values" will show the color correctly...
Best Regards
Hi Anonymous ,
Thank you for your response. Unfortunately, this solution does not quite meet my requirements. I cannot use the rules in Conditional Formatting tab. The presented example is a simplification of a report I am preparing for my organization. In the report, the threshold value (in this case number 8 ) is not a fixed number but instead a dynamic number that can be set using a slicer. To my knowledge, Conditional Formatting rules only allow definition of fixed threshold values, and therefore it cannot be used in my situation. Using a measure created via DAX is the only way I can think of to achieve the goal.
Naturally, there is the possibility to replace blank values with 0. It makes the matrix harder to read, but its the only workaround I could come up with to make this work. Still, I'd like to come up with a DAX solution that colours the blank fields, or come to a conclusion that it is not possible.
Hi Anonymous ,
I tried to find other possible ways (conditional formatting Format style as Field value), but it failed... At the moment it seems to be possible to find a more feasible way which is the way you mentioned in your reply that the blank value will be treated as 0 when calculating the hours, and then the data with "blank values" will show the color correctly...
Best Regards
juan_pabloHelper V
Hi. I have the same issue and definetly this must be a bug. When the measure in the matrix visual is empty, the formatting measure is not even evaluated (you can test this by making the formatting measure a constant, and still, the matrix cell will be formatted as if it is empty when the matrix measure is empty, ignoring the formatting measure completely).
When you include the formatting measure in the matrix, the formatting measure now is evaluated even then the matrix measure is empty and it works as expected.
How can this be fixed?
(I can't use the 0 solution because I have a line chart that would display ALL dates because of the 0 even when the dates are filterede out (autoexist wouldn't apply and the line chart would explode ignoring the date filter)).