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!
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:
Find the "Use thousands separator" toggle
Enable/disable as needed while maintaining your decimal settings
Choose between different separator styles (e.g., 1,234.56 or 1 234.56)
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
Comments