Replacing the word "(Blank)" in gauge

[TechR21]

Hi,

I have a gauge visual, which uses a measure to calculate the percentage of number of days in a week that a specific value in a column was below 5.0 or not. Now i have a week that all values are above 5.0 , so gauge is 0% --> and gives me a blank value in the visual itself.

measure i use:

VAR less5 =
CALCULATE ( COUNT ( 'table'[column] ), KEEPFILTERS ( 'table'[column] < 5.0 ) )
RETURN
DIVIDE ( less5, 7 )

Is there a way to replace this word "(Blank)" , like a text or something?

[ahmedoye]

The last part of your DAX is where you need to edit to the below:

DIVIDE ( less5, 7, 0)

If this works for you, kindly mark as a solution to allow others who may have similar issues find it easily.

[olgad]

VAR less5 =
CALCULATE ( COUNT ( 'table'[column] ), KEEPFILTERS ( 'table'[column] < 5.0 ) )

var final=DIVIDE ( less5, 7 )
RETURN
If(Isblank(final), "0%", final)

[TechR21]

doesnt seem to work, still see "(Blank)"

[olgad · Accepted solution]

Hi, checked it, so it wants a number, if you just write 0 in that last part, you will be good

 If(Isblank(final),0, final)

if you want a text, then use the card visual and put it on top of the value in the gauge. 

[TechR21]

yes this works, thank you

[olgad]

in your measure calculation
if(isblank(YOUR CALCULATION), "No values", YOUR CALCULATION)

For example 
if(isblank(Sum(new[target])), "No values", Sum(new[target]))

[TechR21]

I forgot to include my measure, which is now included in my post. Can i still include your line in there?

[olgad]

If not blank, what text would you like to have there? And it is a gauge right?

[TechR21]

yes you are right, its a gauge! sorry. Doesnt matter the text, something like "all times are below 5.0", or "0%" for example