Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
RajaSadagopan
New Contributor

Display the values with comma for visualisations

RajaSadagopan_0-1727014147147.png


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 2
dharmendars007
Valued Contributor

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
Contributor III

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

KerKol_0-1731316324607.png

 





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

Proud to be a Super User!




Helpful resources

Announcements
Top Kudoed Authors
Users online (6,084)