Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Errors in custom field format

Hi All, any idea why in desktop all fields with custom format (columns and measures) showing output as below? I used desktop on 10th March and all was ok. Goal is to keep currency numbers with spac...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Anonymous ,

     

    Pls go to model view,select the measure>format>custom,key in the format you need:

     

    Check whether the example is what you need.

     

    Best Regards,
    Kelly

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I used measure tools > format field. 

 

For this crashed numbers I have there now: '\$ \#\#\# \#\#\# \#\#\0.\#\;-\$ \#\#\# \#\#\# \#\#\0.\#\;\$ \#\#\# \#\#\# \#\#\0.\# it looks like PBI added \ between all symbols. 

Now if I replace it works well, but replacing it for over 70 measures will be a pain 😞 

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Pls go to model view,select the measure>format>custom,key in the format you need:

     

    Check whether the example is what you need.

     

    Best Regards,
    Kelly

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