How to add commas to numbers in Power BI [QUICK GUIDE]

by Milan Stanojevic
Milan Stanojevic
Milan Stanojevic
Windows & Software Expert
Milan has been enthusiastic about PCs ever since his childhood days, and this led him to take interest in all PC-related technologies. Before joining WindowsReport, he worked as... read more
Affiliate Disclosure
XINSTALL BY CLICKING THE DOWNLOAD FILE
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

Power BI is a tool that could bring the best out of any project, but sometimes, this great Microsoft product is plagued by little but important issues.

For example, many users don’t know how to add commas to numbers in Power BI, because this option is not as obvious as it should have been.

One user opened a thread on the official forum and said the following:

I’m starting to learn Power BI to gauge it’s possible used for my company. I’ve been looking around and find tutorials to understand some of the inner workings. Current I’m following the tutorial here. The issue I’m having is when I create card visualizations the numbers appear unformatted without commas. How can I get them to format with commas?

commas numers power bi
So, the numbers appear without any commas, but this is not what the OP intended.

Fortunately, this issue can be solved without any difficulty.

Steps to add commas to numbers

Select the option from the Modelling tab

  1. Go to the Modelling tab.
  2. At Formatting, select the format you want, in this case, the comma symbol (,).

power bi formatting commas
Along with commas, you can select other symbols for your numbers such as percentage or currency.


Learn more about Power BI by reading this guide.


Conclusion

To add commas to your numbers is pretty simple. It is an option in the Modelling tab which you can select with just one click.

So, there you have it, a simple solution for an important question!

How do you format numbers in Power BI? Do let us know in the comment section below!

RELATED STORIES YOU NEED TO CHECK OUT:

idee restoro Still having issues? Fix them with this tool:
  1. Download this PC Repair Tool rated Great on TrustPilot.com (download starts on this page).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues with Patented Technologies (Exclusive Discount for our readers).

Restoro has been downloaded by 0 readers this month.

This article covers:Topics: