Forum Discussion
Swiss Localization not Working as expected
I am trying to localize the number formats and want to have the decimal separators displayed as apostrophes. Expected Example: 127'931'598,50 CHF Current Formatting: 127.931.598,50 CHF Sadly...
Hi TimGabriel ,
Try formatting the output like this:
Format Total Gross Sales = SUBSTITUTE( FORMAT( SUM('Table'[Gross Sales]), "#,##0.#0" & " CHF"), ",", "'" )
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Thanks! This partially worked. I was able to create a measure like this, however, I can't use it in the visuals I need (e.g. a decomposition tree). See attached file: