Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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)
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:
Regards,
Xiaoxin Sheng
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.
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)
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |