Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX

So I created a measure and values are like below

 

 

I want Include thousands separator how do this

Need Help
Tips and Tricks
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi Anonymous ,

    You could try formatting like below:-

    Measure = FORMAT([value]),"$#0,000,00")

     

    Thanks,

    Samarth

5 Replies

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    Hi Anonymous ,

    You could try formatting like below:-

    Measure = FORMAT([value]),"$#0,000,00")

     

    Thanks,

    Samarth

  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    HI Anonymous ,

     

    I see you already have a thousand separator to your measure value with currency symbol.

    Can you elaborate more on what you want?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I want to show separator after every 3 digits

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    So I want to show like this $10,716,286

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    Hi, Anonymous ;

    You just have to choose the measure. Then change its format by clicking ", "and" $", as shown below

    The final output is shown below:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.