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...
In the above screenshot, you can see I have selected the measure - "Total Revenue".
Under the format Tab, the format Is General.
---- Switch the format to Currency.
---- Also adjust the decimal points to two places.
DONE.
Check the above screenshot. You can check the card which shows Monthly revenue and check the values as they add a "K" or "M" when required.
I