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 space as thousand separator. Now instead of right numbers I have following values in all my tables/charts etc:

 

"$ ### ### ##0#;-$ ### ### ##0"

 

 

 

 

 

 

 

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!

4 Replies

  • 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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for feedbacks, I change format in all measures again in desktop format place listed above. Works for now.