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 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()??
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)

     

2 Replies

  • 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)

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    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)