How to Add or Remove Decimals in Looker Studio

Q: How do I set different decimal places for multiple metrics in the same chart?

You can customize decimal places for each metric individually: 1. Navigate to the Style tab in your chart settings 2. Locate 'Metric styles' section 3. Click on each metric to expand its settings 4. Under 'Number format,' set your desired decimal places 5. Each metric can have its own unique decimal configuration. Pro tip: You can also apply conditional formatting rules with different decimal places based on metric values.

Q: Can I add or remove thousand separators while managing decimals?

Yes, you have full control over thousand separators. In the Number format section: 1. Find the 'Use thousands separator' toggle 2. Enable/disable as needed while maintaining your decimal settings 3. Choose between different separator styles (e.g., 1,234.56 or 1 234.56) 4. This setting can be applied alongside any decimal configuration

Q: What are the maximum and minimum decimal places I can set in Looker Studio?

Looker Studio provides flexible decimal range options: Minimum: 0 decimal places (whole numbers), Maximum: 10 decimal places, Scientific notation: Available for very large or small numbers, Custom format strings: Supported for advanced decimal formatting needs

Sotirios Seridis
Oct 24, 2024
2 min read

Updated: Apr 6

Sometimes, those extra decimal places in Looker Studio reports can clutter your data, or maybe you want more precision. Whether you need to clean up your report with fewer digits or add precision for more accurate analysis, it’s a quick fix.

In this guide, we’ll walk you through how to add or remove decimals in Looker Studio, so your reports show exactly the level of detail you need!

► ⭐ Digital Marketing Resources Hub

► 🎥 Follow our YouTube Channel

► 🚀 Work with me

► 🧠 Book a call

► 🔗 Connect on LinkedIn

► ❓ Ask any question

How to Add or Remove Decimals in Looker Studio For Scorecards:

Select the Scorecard
Click on the STYLE column (right-hand-side)
Under Primary Metric, open the dropdown menu
Select the number of decimals

How to Add or Remove Decimals in Looker Studio For Tables and Other Charts:

Select the table or chart
Click on the STYLE column (right-hand-side)
Scroll down and under each metric, open the dropdown menu
Select the number of decimals

Frequently Asked Questions on Adding or Removing Decimals in Looker Studio

How do I set different decimal places for multiple metrics in the same chart?

Yes, you can customize decimal places for each metric individually:

Navigate to the Style tab in your chart settings
Locate "Metric styles" section
Click on each metric to expand its settings
Under "Number format," set your desired decimal places
Each metric can have its own unique decimal configuration

Pro tip: You can also apply conditional formatting rules with different decimal places based on metric values.

Can I add or remove thousand separators while managing decimals?

Yes, you have full control over thousand separators:

In the Number format section:
1. Find the "Use thousands separator" toggle
2. Enable/disable as needed while maintaining your decimal settings
3. Choose between different separator styles (e.g., 1,234.56 or 1 234.56)
4. This setting can be applied alongside any decimal configuration

What are the maximum and minimum decimal places I can set in Looker Studio?

Looker Studio provides flexible decimal range options:

Minimum: 0 decimal places (whole numbers)
Maximum: 10 decimal places
Scientific notation: Available for very large or small numbers
Custom format strings: Supported for advanced decimal formatting needs