https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Display-the-values-with-comma-for-visualisations/m-p/4164907#M10647 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RajaSadagopan_0-1727014147147.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1171251iC16858536E535D88/image-size/medium?v=v2&amp;px=400" role="button" title="RajaSadagopan_0-1727014147147.png" alt="RajaSadagopan_0-1727014147147.png" /></span></P><P><BR />Hi, I want to display the value 3669 with comma. Eg: 3,669. For both the visualisation and tooltip.&nbsp;</P><P><BR />I tried to create calculated measure/column but its not working!!</P><P>&nbsp;</P><DIV><DIV><SPAN>FormattedValues =</SPAN> <SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>Count</SPAN><SPAN>(</SPAN><SPAN>fact_users</SPAN><SPAN>[user_name]</SPAN><SPAN>), </SPAN><SPAN>"#,##0"</SPAN><SPAN>)</SPAN></DIV></DIV> Sun, 22 Sep 2024 14:17:03 GMT RajaSadagopan 2024-09-22T14:17:03Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Display-the-values-with-comma-for-visualisations/m-p/4164907#M10647 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RajaSadagopan_0-1727014147147.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1171251iC16858536E535D88/image-size/medium?v=v2&amp;px=400" role="button" title="RajaSadagopan_0-1727014147147.png" alt="RajaSadagopan_0-1727014147147.png" /></span></P><P><BR />Hi, I want to display the value 3669 with comma. Eg: 3,669. For both the visualisation and tooltip.&nbsp;</P><P><BR />I tried to create calculated measure/column but its not working!!</P><P>&nbsp;</P><DIV><DIV><SPAN>FormattedValues =</SPAN> <SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>Count</SPAN><SPAN>(</SPAN><SPAN>fact_users</SPAN><SPAN>[user_name]</SPAN><SPAN>), </SPAN><SPAN>"#,##0"</SPAN><SPAN>)</SPAN></DIV></DIV> Sun, 22 Sep 2024 14:17:03 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Display-the-values-with-comma-for-visualisations/m-p/4164907#M10647 RajaSadagopan 2024-09-22T14:17:03Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Display-the-values-with-comma-for-visualisations/m-p/4170608#M10753 <P>Hello&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/799530">@RajaSadagopan</a>&nbsp;,&nbsp;</P><P>&nbsp;</P><P>If you're trying to use the result in numerical charts (like bar charts or pie charts), using the Format function will prevent it from being recognized as a number. In such cases, format the number in the chart settings instead.</P><P>&nbsp;</P><P><EM><U><STRONG>If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!</STRONG></U></EM></P><P>&nbsp;</P><P>Thank You</P><P>Dharmendar S</P><P><A href="https://www.linkedin.com/in/dharmendar-s-b5b43463/" target="_blank" rel="noopener"><SPAN>LinkedIN</SPAN></A><SPAN>&nbsp;</SPAN></P> Tue, 24 Sep 2024 12:53:44 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Display-the-values-with-comma-for-visualisations/m-p/4170608#M10753 dharmendars007 2024-09-24T12:53:44Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Display-the-values-with-comma-for-visualisations/m-p/4277985#M11762 <P>Make sure you've the latest version, then under the general settings of the format visual tab, expand Data Format option, select the measure from the drop-down, enable thousands separator</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KerKol_0-1731316324607.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1197546iCF19406F3560319A/image-size/medium?v=v2&amp;px=400" role="button" title="KerKol_0-1731316324607.png" alt="KerKol_0-1731316324607.png" /></span></P> <P>&nbsp;</P> Mon, 11 Nov 2024 09:14:05 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Display-the-values-with-comma-for-visualisations/m-p/4277985#M11762 KerKol 2024-11-11T09:14:05Z