I have a matrix that i want to colour a specific column a certain colour, I have managed to do this via a measure and background conditional formatting. However as some of my values within my column are blank the colour does not fill these parts of may matrix and thefefore the column looks patchy and not really any use.
I am now trying to replace blanks with 0 but i cannot seem to do this without creating new columns in my matrix for dates that I had previously filtered out in my measures.
I’ve tried if(isblank() and also adding +0 to the end of my measure but both methods add new columns for dates that i have previously filtered out within my measures.
You’ll need to find a value <> null to be able to achieve this without additional columns. Usually that will be a column- or line total but could also be an intermediate calc or other measure. Create a conditional test on that value to see if that isn’t null and return a 0 instead.
I hope this is helpful. If you need further assistance provide a sample PBIX with some dummy data.
if I correctly understood your question you do not need to replace blank with 0.
Just go to conditional formatting and add a rule to give a color to blank values like in the image:
