Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Power BI Community,
I am encountering an issue with formatting in Calculation Groups in Power BI. I'm trying to format numbers to display with a thousands separator, two decimal points, and a 'k' suffix to denote thousands.
Currently, I'm using the format string `"0,.0" & "k"` which converts the numbers to thousands but doesn’t include the thousands separator, resulting in outputs like `3370.3k`. My goal is to display these numbers as `3,370.3k` for better readability.
I attempted to use the format string `"#,##0.0,,\"k\""` based on suggestions, but it results in an error.
Could anyone help me correct the format string or provide guidance on how to achieve the desired formatting in Calculation Groups? Any insights or examples would be greatly appreciated!
Thank you for your support!
Solved! Go to Solution.
Try this, which I think is about the simplest format string for
",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
",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 🙂
User | Count |
---|---|
86 | |
83 | |
67 | |
61 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
84 | |
70 |