Forum Discussion
Help with Formatting String in Power BI Calculation Groups to Include Thousands Separator and 'k'
Try this, which I think is about the simplest format string for
- Units of thousands
- Thousands separator
- 2 decimal places
- k suffix
",0,.00k"The ordering of the elements of the format string unfortunately changes depending on whether decimal places are present.
Does the above work?
Try this, which I think is about the simplest format string for
- Units of thousands
- Thousands separator
- 2 decimal places
- k suffix
",0,.00k"The ordering of the elements of the format string unfortunately changes depending on whether decimal places are present.
Does the above work?
OwenAuger you are a genius, it worked perfectly.
Thanks for this note "The ordering of the elements of the format string unfortunately changes depending on whether decimal places are present."
I feel so annoyed i wasted so much time trying to figure this out and you solved it so quickly.
Thanks again
You're welcome!
To elaborate on the point about inconsistent ordering, see this Twitter thread:
https://x.com/insightsmachine/status/1313632903578877952
I have been meaning to write a blog post as much for my own benefit as anyone else's 🙂