Forum Discussion

MohTawfik's avatar
MohTawfik
Icon for Resolver I rankResolver I
3 years ago

DAX conditional format is not working with Blank/ No data cells!

I have Matrix visual where I want to write a DAX formula to format cells based on two conditions, their values and status!   Expected Value Status Format Background color Remarks >0 Won ...
Need Help
MohTawfik's avatar
MohTawfik
Icon for Resolver I rankResolver I
3 years ago

Thanks for your continues support, I came across these two topics but still stuck.

That's a sample file with my data and formula to check

Conditional Format.pbix 

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi MohTawfik ,

 

With your PBIX file I found the problem:
The conditional formatting doesn't work because the blank cells you see don't actually exist, they are created by the intersection of rows and columns. Using blank() doesn't work because they are not values in any real sense.


So if you want them to be conditionally formatted the way you want, the easiest way is to change the default color of the cells in Visual to red, and then conditionally format the other values:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • MohTawfik's avatar
    MohTawfik
    Icon for Resolver I rankResolver I
    3 years ago

    Thanks again, I actually did this solution however it's not very practical as I have different levels of heirarcy where I don't want to keep the same format!
    it's a bit complex one ! 🥴