Forum Discussion

Fusilier2's avatar
Fusilier2
Helper V
1 year ago
Solved

Conditional number rounding

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...
  • BITomS's avatar
    BITomS
    1 year ago

    Hi Fusilier2 ,

     

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

     

    Hope this helps!

BITomS's avatar
BITomS
Solution Supplier
1 year ago

Hi Fusilier2 ,

 

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

 

Hope this helps!

Fusilier2's avatar
Fusilier2
Helper V
1 year ago

Thank you for your help!