Forum Discussion
Resolver IDAX conditional format is not working with Blank/ No data cells!
Resolver IThanks 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
Community SupportHi 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
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 ! 🥴