Conditional number rounding

[Fusilier2]

Can anybody recommend a solution to this:

I have monthly data values that will always be between 0% and 100% but never higher than 100%.

They are displayed in a visual with labels turned on. What I want to achieve for the data labels is, if the value is < 100% to display to 1 decimal point (e.g. 98.7%), but if the value = 100% to display with no decimal points )100%).

Is that possible? I presume by using a measure?

[BITomS · Accepted solution]

Hi @Fusilier2 ,

FormattedPercent =
VAR BaseValue = SUM('Table'[PercentValue])
RETURN
IF(
BaseValue = 1,
FORMAT(BaseValue, "0%"),
FORMAT(BaseValue, "0.0%")
)

Hope this helps!

[123abc]

Excellent ... Good solution 👍

[Fusilier2]

Thank you for your help!