https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-number-rounding/m-p/4710572#M180398 <P>Can anybody recommend a solution to this:</P><P>I have monthly data values that will always be between 0% and 100% but never higher than 100%.</P><P>They are displayed in a visual with labels turned on. What I want to achieve for the data labels is, if the value is &lt; 100% to display to 1 decimal point (e.g. 98.7%), but if the value = 100% to display with no decimal points )100%).</P><P>Is that possible? I presume by using a measure?</P><P>&nbsp;</P> Wed, 28 May 2025 13:55:48 GMT Fusilier2 2025-05-28T13:55:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-number-rounding/m-p/4710572#M180398 <P>Can anybody recommend a solution to this:</P><P>I have monthly data values that will always be between 0% and 100% but never higher than 100%.</P><P>They are displayed in a visual with labels turned on. What I want to achieve for the data labels is, if the value is &lt; 100% to display to 1 decimal point (e.g. 98.7%), but if the value = 100% to display with no decimal points )100%).</P><P>Is that possible? I presume by using a measure?</P><P>&nbsp;</P> Wed, 28 May 2025 13:55:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-number-rounding/m-p/4710572#M180398 Fusilier2 2025-05-28T13:55:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-number-rounding/m-p/4710593#M180399 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="554477" data-lia-user-login="Fusilier2" class="lia-mention lia-mention-user">Fusilier2</a>&nbsp;,</P><P>&nbsp;</P><P>FormattedPercent =<BR />VAR BaseValue = SUM('Table'[PercentValue])<BR />RETURN<BR />IF(<BR />BaseValue = 1,<BR />FORMAT(BaseValue, "0%"),<BR />FORMAT(BaseValue, "0.0%")<BR />)</P><P>&nbsp;</P><P>Hope this helps!</P> Wed, 28 May 2025 14:01:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-number-rounding/m-p/4710593#M180399 BITomS 2025-05-28T14:01:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-number-rounding/m-p/4710649#M180401 <P>Thank you for your help!</P> Wed, 28 May 2025 14:32:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-number-rounding/m-p/4710649#M180401 Fusilier2 2025-05-28T14:32:31Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-number-rounding/m-p/4711711#M180453 <P>Excellent ... Good solution <span class="lia-unicode-emoji" title=":thumbs_up:">👍</span></P> Thu, 29 May 2025 08:36:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-number-rounding/m-p/4711711#M180453 123abc 2025-05-29T08:36:28Z