Replacing an empty space in a table visual with 100%

[Herritage_95]

Good day , please assist i want on the visualization all the empty spaces to show 100% using a formula

[mlsx4]

Hi @Herritage_95 

You can do it using an if in the measure you are displaying. Let's say:

Measure = 

var _result= [Value]

RETURN IF (ISBLANK(_result), 1,_result)

 P.S. I have put 1 because I assume you are formatting decimal values between 0 and 1... otherwise, put 100