Forum Discussion

Herritage_95's avatar
Herritage_95
Frequent Visitor
3 years ago

Replacing an empty space in a table visual with 100%

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

1 Reply

  • mlsx4's avatar
    mlsx4
    Icon for Memorable Member rankMemorable Member

    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