Forum Discussion
Dynamic Formatting for Thousands & Millions
Hi all, I wonder if anyone can suggest a means of using the custom format capabilities of PowerBI to replicate what in Excel would look like this: [>=1000000] #,##0.00,,"m";[<1000000] #,##0.0...
Power BI can now do this. It is called dynamic format strings
Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn
Hi TrevLc Thanks for pointing this out. But have you been able to make it work with the "commas" to divde the number by 1000, 1000000 etc.? I tried but it does not seem like it is implemented in the Dynammic format strings?