Forum Discussion
Visual - > Card -> Data Format
I want to show all the values with comma as the thousand separator. For example, 22,505, and not 22.505K.
Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn says #,##0 it should work, but I could not get it to work. Any help would be appreciated. Thanks.
Hi, you would need to first give 'Display Unit' under 'Value' 'None' before custom formatting it under Properties.
3 Replies
Hi thiamhuat2026,
Select the measure and unbder home menu click on "," to add comma as separator.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!Select your Total Cases measure in the Fields pane → go to Modeling tab → Format → Custom → type the format string: "#,##0"
Hi, you would need to first give 'Display Unit' under 'Value' 'None' before custom formatting it under Properties.
