https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/currency-in-lacs-or-crores-in-column-chart-labels/m-p/3129800#M111303 <P>Hello ,i want to diplay currency in indian format that is lacs and crores in column chart lables , please help thanks in advance&nbsp;<BR /><BR /><img /></P> Tue, 14 Mar 2023 05:14:19 GMT Anonymous 2023-03-14T05:14:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/currency-in-lacs-or-crores-in-column-chart-labels/m-p/3129800#M111303 <P>Hello ,i want to diplay currency in indian format that is lacs and crores in column chart lables , please help thanks in advance&nbsp;<BR /><BR /><img /></P> Tue, 14 Mar 2023 05:14:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/currency-in-lacs-or-crores-in-column-chart-labels/m-p/3129800#M111303 Anonymous 2023-03-14T05:14:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/currency-in-lacs-or-crores-in-column-chart-labels/m-p/3130227#M111338 <P>Use display unit as None or use this measure<BR />Denominations = var a = [Measure]/10<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var b = switch(<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;True(),<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a&gt;= 10000000,Round(divide(a,10000000),2) &amp; "Crore",<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;a&gt;= 100000,Round(divide(a,100000),2) &amp; "Lakhs",)<BR />return b<BR /><BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> Tue, 14 Mar 2023 08:56:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/currency-in-lacs-or-crores-in-column-chart-labels/m-p/3130227#M111338 Anonymous 2023-03-14T08:56:12Z