Dynamic Format Strings Bug

[QC]

There is a bug with the new "Dynamic Format Strings" function, as you can see from eample below, the 2 simple measures "Format 1 & 2" have the exact same DAX (simple sum), both set to "dynamic", with slightly different dyn-format in '000 (one with no decimal, one with 1 decmial). The one with no decimal is not showing up correctly (not showing in '000 as supposed to). Please fix this bug.

Reference:

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-new-dynamic-format-strings-for-measures/

Version: PBI Desktop April 2023

[Anonymous]

Hi @QC 

I tried to restore the scenario you mentioned but failed, can you provide your pbix file(remove sensitive info) for reference ?

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Community Support Team _ Ailsa Tao

[QC]

Nvm, I found the issue: adding a "." after "," worked

SWITCH(

    TRUE(),

    ABS(SELECTEDMEASURE()) < 1000, "#,##0",

    ABS(SELECTEDMEASURE()) < 1000000, "#,##0,.K",

    "#,##0,,.M"

)

[suparnababu8]

Hi The same issue I'm also facing the similar issue in Scatter chart. After implementation of Dynamic format. then I selected X-axis-->Values-->Display units to None. After this selection, It's is displaying as normal numbers in x-axis instated of K,Mn,Bn. I used the below measure for dynamic formatting. Total Sales = SUM(SuperStoreUS[Sales]) Dyn Format measure : VAR TTLSALES = [Total Sales] RETURN SWITCH(TRUE(), TTLSALES<1000,"0", TTLSALES<1000000,"#,.0K", TTLSALES<1000000000,"#,,.0Mn", TTLSALES>=1000000000,"#,,,.0Bn") Here I don't have option to upload sample report . @Micorsoft Fabric Community Pls help on this.