Forum Discussion

RajaSadagopan's avatar
RajaSadagopan
Regular Visitor
1 year ago

Display the values with comma for visualisations


Hi, I want to display the value 3669 with comma. Eg: 3,669. For both the visualisation and tooltip. 


I tried to create calculated measure/column but its not working!!

 

FormattedValues = FORMAT(Count(fact_users[user_name]), "#,##0")

2 Replies

  • dharmendars007's avatar
    dharmendars007
    Memorable Member
    1 year ago

    Hello RajaSadagopan , 

     

    If you're trying to use the result in numerical charts (like bar charts or pie charts), using the Format function will prevent it from being recognized as a number. In such cases, format the number in the chart settings instead.

     

    If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

     

    Thank You

    Dharmendar S

    LinkedIN 

  • KerKol's avatar
    KerKol
    Power Participant
    1 year ago

    Make sure you've the latest version, then under the general settings of the format visual tab, expand Data Format option, select the measure from the drop-down, enable thousands separator