Question

Can we have the Y axis scale abbreviated?

  • 17 February 2021
  • 3 replies
  • 23 views

Hi,

 

My Y axes are usually in billions, and often requires me to verbally say it in presentation without having people count the tiny zeroes. Any chance we can abbreviate it in looker directly?


3 replies

Userlevel 2
Badge

Hi @thedataguy,

Have a look here: https://docs.looker.com/exploring-data/visualizing-query-results/column-options#y_axis_format

Hi David, this doesn't help as my data fluctuates between Millions and Billions. Hard coding wouldn’t be the best practice for my dashboard unfortunately. Pretty shocked that Looker doesn’t have this by default.

Userlevel 2
Badge

The custom format follows the excel formatting, you can try something like this:

 [<999950000]0.0,, "M";0.0,,, "B"

and then it would automatically adjust to both million and billion values

Reply