Solved: Formatting in Calculation Groups

mp390988 · ‎11-01-2025

Hi,

How can I format these values to the nearest whole number with a thousand seperator?
I can't use the data format in the formatting pane as I am working with calculation groups and the last metric (IB%) in this visual is a percentage whilst the rest are numbers.

Thanks

danextian · ‎11-01-2025

Hi @mp390988

You can apply dynamic format string to a calculation item.

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

v-sshirivolu · ‎11-05-2025

Hi @mp390988 ,
I would like to take a moment to thank @danextian , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

v-sshirivolu · ‎11-09-2025

Hi @mp390988 ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

danextian · ‎11-01-2025

Hi @mp390988

You can apply dynamic format string to a calculation item.

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.