Bullet chart OK viz conditional colour doesn't apply if target is blank

[KCinMelbourne]

Hi all,

I've been using the Bullet Chart by OK Viz and set it up for the bar to turn red if the value exceeds budget. I noticed however if the item doesn't have a budget (returns BLANK() instead of 0), the bar does not turn red. 

Wondering if anyone else has experienced this?  I am hoping it is user error.

If not, any workarounds? I'm thinking of modifying the measures to show 0 instead of blank but it's an annoying workaround.

For reference, I did raise the issue with OK Viz here but as they don't guarantee a response, I thought I'd ask the community too. 

Cheers

KC

[Anonymous]

Hi @KCinMelbourne ,

I'd like to suggest you to contact to visual author to get better support, you can try to post at the official site:

OK VIZ support

Regards,

Xiaoxin Sheng

[KCinMelbourne]

Thanks for your response but as per the original post, I've already done that and they don't guarantee a response. That's why I am asking here too.

[KCinMelbourne · Accepted solution]

I've received advice from OK Viz that it is not possible to conditionally colour code a visual if the target is Blank(), so a measure such as the following would be required.

= IF (ISBLANK(MeasureName), 0, MeasureName)