Forum Discussion
Herritage_95
3 years agoFrequent Visitor
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
Memorable 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