Forum Discussion
EeeeenieMac
2 years agoRegular Visitor
Bar chart behaviour
Hi there PLEASE can somebody put me out of my misery? I've been trying to get to the bottom of this for a couple of days now without any joy. My customer would like to select a Customer and ...
imac
2 years agoRegular Visitor
I'm happy to say that I have resolved this. The reason for the behaviour, I think, is because two of my measure yielded <blank> in their default state. Only when a Company was selected did they correctly calculate. The BarChart visuals need default values for the outer container.
To fix this I simply added IF(ISBLANK([cptMeasure]), [DefaultValue], [cptMeasure]).