https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Dynamic-Number-Format/m-p/4029293#M1111 <P>This can be used after selecting the "Dynamic" as the measure format under "Measure tools"</P><P><img /></P><LI-CODE lang="markup">VAR CurrentValue = SELECTEDMEASURE() RETURN SWITCH ( TRUE (), // format the number based on value CurrentValue &lt;= -1E6, "#,0,,.00 M", CurrentValue &lt;= -1E3, "#,0,.00 K", CurrentValue &lt;= 1E3, "#,0.00", CurrentValue &lt; 1E6, "#,0,.00 K", CurrentValue &lt; 1E9, "#,0,,.00 M", CurrentValue &lt; 1E12, "#,0,,,.00 B" )</LI-CODE><P>I&nbsp;</P> Mon, 08 Jul 2024 04:31:00 GMT aduguid 2024-07-08T04:31:00Z https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Dynamic-Number-Format/m-p/4029293#M1111 <P>This can be used after selecting the "Dynamic" as the measure format under "Measure tools"</P><P><img /></P><LI-CODE lang="markup">VAR CurrentValue = SELECTEDMEASURE() RETURN SWITCH ( TRUE (), // format the number based on value CurrentValue &lt;= -1E6, "#,0,,.00 M", CurrentValue &lt;= -1E3, "#,0,.00 K", CurrentValue &lt;= 1E3, "#,0.00", CurrentValue &lt; 1E6, "#,0,.00 K", CurrentValue &lt; 1E9, "#,0,,.00 M", CurrentValue &lt; 1E12, "#,0,,,.00 B" )</LI-CODE><P>I&nbsp;</P> Mon, 08 Jul 2024 04:31:00 GMT https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Dynamic-Number-Format/m-p/4029293#M1111 aduguid 2024-07-08T04:31:00Z