Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to hide BLANK() in KPI visual?

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 wi...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
speedramps
Icon for Super User rankSuper User
4 years ago

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)