Dynamic Format Strings Bug

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.

 

Capture.JPG

 

Reference:

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

 

Version: PBI Desktop April 2023

Needs Info
Comments
avatar user
Anonymous
Not applicable

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
Kudo Kingpin
Kudo Kingpin

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

 

SWITCH(
    TRUE(),
    ABS(SELECTEDMEASURE()) < 1000, "#,##0",
    ABS(SELECTEDMEASURE()) < 1000000, "#,##0,.K",
    "#,##0,,.M"
)
suparnababu8
Super User
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.