https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formatting-String-Percentages/m-p/3337134#M125160 <P>Hello!</P><P>&nbsp;</P><P>I am working with the new dynamic formatting for measures. I am trying to format the bold section below as a percentage with no decimal places; however, it isn't picking up the zeros. I would like them to say 0%. is there a way to fix this?&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>VAR</SPAN> <SPAN>_Measure</SPAN><SPAN> = </SPAN><SPAN>SELECTEDMEASURE</SPAN><SPAN>()</SPAN></DIV><DIV><SPAN>return</SPAN></DIV><DIV><SPAN>SWITCH</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>TRUE</SPAN><SPAN>(),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>_Measure</SPAN><SPAN> = </SPAN><SPAN>[Total Metric]</SPAN><SPAN>, </SPAN><SPAN>"0"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; <STRONG>&nbsp; </STRONG></SPAN><STRONG><FONT color="#800000">_Measure = vw_CNMetrics[Metric% average per Month], &nbsp;"0%")</FONT></STRONG></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P></DIV></DIV> Tue, 18 Jul 2023 17:57:21 GMT crjackson 2023-07-18T17:57:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formatting-String-Percentages/m-p/3337134#M125160 <P>Hello!</P><P>&nbsp;</P><P>I am working with the new dynamic formatting for measures. I am trying to format the bold section below as a percentage with no decimal places; however, it isn't picking up the zeros. I would like them to say 0%. is there a way to fix this?&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>VAR</SPAN> <SPAN>_Measure</SPAN><SPAN> = </SPAN><SPAN>SELECTEDMEASURE</SPAN><SPAN>()</SPAN></DIV><DIV><SPAN>return</SPAN></DIV><DIV><SPAN>SWITCH</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>TRUE</SPAN><SPAN>(),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>_Measure</SPAN><SPAN> = </SPAN><SPAN>[Total Metric]</SPAN><SPAN>, </SPAN><SPAN>"0"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; <STRONG>&nbsp; </STRONG></SPAN><STRONG><FONT color="#800000">_Measure = vw_CNMetrics[Metric% average per Month], &nbsp;"0%")</FONT></STRONG></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P></DIV></DIV> Tue, 18 Jul 2023 17:57:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formatting-String-Percentages/m-p/3337134#M125160 crjackson 2023-07-18T17:57:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formatting-String-Percentages/m-p/3337244#M125164 <P>Hi,</P><P>Have you used the Format() function?</P><P><img /></P> Tue, 18 Jul 2023 19:53:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formatting-String-Percentages/m-p/3337244#M125164 baghdadi62 2023-07-18T19:53:08Z