Forum Discussion
Advocate IVSummarise Value disabling conditional formatting on another column
Hi jimbob2285 ,
This is because the Amount column contains blank value, I recommend you add a new column and check if Amount value is blank, if it is blank, then replace blank with 0.
sub_Amount = IF(ISBLANK(Submissions[AMOUNT]),0,Submissions[AMOUNT])Best regards,
Mengmeng Li
Super User I've tried to replicate the issue with some test data, but that seems to be working fine, when the value is summarisedSo you are saying you cannot reproduce the issue?
Advocate IVHi lbendlin
Yes, that's correct, but if you download the PBIX file from the link in my original post, you can see that the top two tables are identical, all bar the value column in the right-hand table is summarised (Summed), which is disabling almost all of the conditional formatting on the Project Count and Project columns.
If you change the Value column in the right-hand table to Don't summarise, then the conditional formatting re-appears, as it is in the left-hand table, which already has the Value column set to Don't summarise
In the bottom two tables, I've tried to replicate the issue with soem simple test data, but cannot, and as I'm sure you'll be familiar with, it's nigh on impossible to fix a problem that you can't replicate...
So I've reached out to the gruop with an example of the strange activity in the linked PBIX
I woudl be really greatful if anyone can tell me why it's behaving in this way, there must be something that I'm missing, something that's in my original data, that's not in my test data sample, but I can't see what it is
Cheers
Jim