How to hide BLANK() in KPI visual?

[Anonymous]

KPI visual shows BLANK() when there is a GOAL but not callout value.

I tried creating a measure to modify the green colour and show it white (#ffffff) to hide the Blank() within the background with this:

Green = if(ISBlank(LASTNONBLANKVALUE('RAM Indicator ratings'[Target value],0)),"#ffffff","#1AAB40") 

But it is still showing green.

Would you have any idea on how to hide the blank()??

[Anonymous · Accepted solution]

Thanks for your answers, but... placing a 0 does not work, because 0 means 0 and it's different than blank. Also, the second option is not valid for KPI visual, which needs a numeric number.

The solution I found was using LEN(). if (LEN(measure) >0, #colour, #transparent)

[speedramps]

Hi HoracioRek

Please consider these 2 options and click thumbs up and accept as solution buttons. Thanks 😎

 I have added comments to expalin how they work

Answer1 =

// By adding zero you can force dax to always return 0 instead of blank

0 +

LASTNONBLANKVALUE('RAM Indicator ratings'[Target value],0) 

Answer2 =

// Use the if command to return "" insteas of blanks

VAR answer = LASTNONBLANKVALUE('RAM Indicator ratings'[Target value],0) 

return

IF(ISBLANK(answer), "", answer)