Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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.
HoracioRek_0-1652460628835.png

 

Would you have any idea on how to hide the blank()??
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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)

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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
Super User
Super User

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)

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.