Dynamic Formatting not working properly

Question

Hello everyone,&nbsp;&nbsp;I am having some issues with the dynamic formatting of a measure. I am using this simple code in the format:&nbsp;&nbsp;SWITCH&nbsp;(&nbsp;&nbsp;&nbsp; TRUE&nbsp;(),&nbsp;&nbsp;&nbsp; SELECTEDMEASURE&nbsp;() &gt;=&nbsp;0 &amp;&amp;&nbsp;SELECTEDMEASURE&nbsp;() &lt;&nbsp;1000,FORMAT&nbsp;(&nbsp;SELECTEDMEASURE&nbsp;(),&nbsp; "#0 "&nbsp;),&nbsp;&nbsp;&nbsp; SELECTEDMEASURE&nbsp;() &gt;=&nbsp;1000 &amp;&amp;&nbsp;SELECTEDMEASURE&nbsp;() &lt;&nbsp;1000000,&nbsp;FORMAT&nbsp;(&nbsp;SELECTEDMEASURE&nbsp;(),&nbsp; " #,##0,.0 k"&nbsp;),&nbsp;&nbsp;&nbsp; SELECTEDMEASURE&nbsp;() &gt;=&nbsp;1000000 &amp;&amp;&nbsp; SELECTEDMEASURE&nbsp;() &lt;&nbsp;1000000000,FORMAT&nbsp;(&nbsp;SELECTEDMEASURE&nbsp;(),"#,##0,,.0 M"&nbsp;),&nbsp;&nbsp;&nbsp; SELECTEDMEASURE&nbsp;() &gt;=&nbsp;1000000000,FORMAT&nbsp;(&nbsp;SELECTEDMEASURE&nbsp;(),&nbsp;"#,##0,,,.0 bn"))&nbsp;I am using this measure in a bar chart with a category in the y-axis and for some categories the data label is misformatted, see image bellow:&nbsp;&nbsp;Has anyone had the same issue?&nbsp;&nbsp;Thank you&nbsp;

beabf · Answer

Rita_Vaz&nbsp;Try with:SWITCH (TRUE (),SELECTEDMEASURE () &gt;= 0 &amp;&amp; SELECTEDMEASURE () &lt; 1000, FORMAT ( SELECTEDMEASURE (), "#0" ),SELECTEDMEASURE () &gt;= 1000 &amp;&amp; SELECTEDMEASURE () &lt; 1000000, FORMAT ( SELECTEDMEASURE (), "#,##0,.0 K" ),SELECTEDMEASURE () &gt;= 1000000 &amp;&amp; SELECTEDMEASURE () &lt; 1000000000, FORMAT ( SELECTEDMEASURE (), "#,##0,,.0 M" ),SELECTEDMEASURE () &gt;= 1000000000 &amp;&amp; SELECTEDMEASURE () &lt; 1000000000000, FORMAT ( SELECTEDMEASURE (), "#,##0,,,.0 Bn" ),SELECTEDMEASURE () &gt;= 1000000000000, FORMAT ( SELECTEDMEASURE (), "#,##0,,,.0 Tn" ))BBF

rita_vaz · Answer

Hello,&nbsp;&nbsp;Thank you for your fast response!I tried the code you sent but the issue still remains 😞&nbsp;&nbsp;&nbsp;

beabf · Answer

Rita_Vaz&nbsp;can you share the pbix file or the sample data under the visual?

rita_vaz · Answer

Hello, I cannot share the pbix file but I tried also with the contoso dataset but I encountered the same issue:&nbsp;&nbsp;

Forum Discussion

Dynamic Formatting not working properly

4 Replies

Related content

Dynamic Formatting Error

Dynamic formatting

Dynamic number format

Dynamic String Format

dynamic conditional formatting