Detecting all blanks

Question

Morning all,&nbsp;I have a matrix of data and am trying to conditionally format the background so that "Actuals" have a grey background colour.&nbsp;&nbsp;Obviously I have some non-existant rows that are producing blanks cells, that are therefore not detected by the conditional formatting I'm using. I have put in an ISBLANK function to change all blanks to "-" and you can see it;s not capturing them all. Is there any way I can capture EVERY blank cell in the matrix using DAX?

anonymous · Answer

Hi&nbsp;EpicTriffid&nbsp;,
&nbsp;
This is a property of matrices, and if you don't have rows and columns of blank values in your original data, it's hard to detect them.
For example, I create a measure that returns 0, but the year 2023 of B in the matirix are blank.

This is because in the original data, there is no B for 2023.

If you want to make your matrix blank values return the color you want, you need to change the original data, which is more troublesome, and this is the advice I can provide.
&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;
&nbsp;

epictriffid · Answer

Thanks for the reply&nbsp;Anonymous&nbsp;&nbsp;Is it possible to fix the issue by using a seperate dimension table in the columns bits of the matrix? So my years would be pulled from that table?

Forum Discussion

Detecting all blanks

2 Replies

Related content

Detected Type Mismatches

detect runtime

Detected Type Mismatches

Blank Page - Embedded Report

A Circular Dependency was detected