top of page
Writer's pictureSotirios Seridis

How to Add or Remove Decimals in Looker Studio

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:


  1. Select the Scorecard

  2. Click on the STYLE column (right-hand-side)

  3. Under Primary Metric, open the dropdown menu

  4. Select the number of decimals



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


  1. Select the table or chart

  2. Click on the STYLE column (right-hand-side)

  3. Scroll down and under each metric, open the dropdown menu

  4. 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:

  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.



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



Comments


bottom of page