Forum Discussion

ashraf_martin's avatar
ashraf_martin
Regular Visitor
2 years ago
Solved

Help with Formatting String in Power BI Calculation Groups to Include Thousands Separator and 'k'

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...
Need Help
  • OwenAuger's avatar
    OwenAuger
    2 years ago

    Hi ashraf_martin 

    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?

ashraf_martin's avatar
ashraf_martin
Regular Visitor
2 years ago

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