Is there a way to change font size in "SINGLE VALUE" Visualizations

HI all I am trying to change font size of single value visualizations kindly provide solution for my problem.

Thank You

11 37 10.4K
37 REPLIES 37

Hi @arigela_vignesh, that isn’t currently possible but I will let the product team know you’re interested in this!

I really need this too 🙂 Is there a better way to vote for a product suggestion rather that replying to a thread like I am doing now?

@Aron_Clymer Responding to a discourse post is a great way to let us know that you’re interested in a suggested product idea. You can also visit help.looker.com if you’re more comfortable writing an email.

srivera1
Participant III

The documentation here states that you can do this using

font_size: small | medium | large

But this does not appear to work.

Hello @srivera1, are you building a User Defined Dashboard or a LookML dashboard?

srivera1
Participant III

I’m building LookML dashboards.

Hi @srivera1, it looks like we have stopped supporting font_size for single value visualizations. I’ll work on getting that removed from the docs.

srivera1
Participant III

Not a problem. I figured that was the case since changing the font size mixed with the dynamic dashboard layouts could be difficult.

Thanks for the update.

p_talkad
Participant III

Will you be bringing it back? Would be useful if we could adjust the size of the Single Value.

Hi @p_talkad, I’ll let the product team know that this is a feature that you’re interested in. For now, you should be able to accomplish this with html formatting like so:

dimension: formatted_field
sql: ${TABLE}.field_name
html: <font size="10">{{ value }}</font>

I’m also interested in this. There are times that I want a specific single value to be much larger than other single values. Currently even when using the font size property in html, all fonts are resized to the same size, which defeats the purpose.

Can this be raised?

@Matthew_Darwin, yes I will let our team know that you will want to have control over the font size in the option of the Single Value visualization.
For the time being, if you try to apply this to one specific Single Value viz, I would suggest making an additional measure, using the same code but changing the html for that new field and define the Single Viz on this measure to show it larger than other Single Viz using the same data.

Hi Romain; unfortunately that doesn’t work. The displayed text size is the same for all single value tiles on the dashboard.

The dimensions in the following image are coded thus:-

  dimension: email {
    type: string
    sql: ${TABLE}.Email ;;
    description: "The Agent's email address"
    html: <font size="20">{{ value }}</font> ;;
  }

  dimension: name {
    type: string
    sql: ${TABLE}.Name ;;
    description: "The Agent's name."
    html: <font size="50">{{ value }}</font> ;;
  }

Yet in the dashboard they are sized the same.

It looks like whatever the size is specified as, it is then being overriden by the single value wrapper class.

I see, thank you for the update Matthew. I am relaying this to our product team now!

Matt, my hack, if you can call it that, was to use a table visualization for HTML measure instead of single value visualization.Table Viz respects the HTML formatting better. I would then hide the row number, other dimensions and use soft hypen as the column header name for the HTML measure. It is not clean, but works.

Thanks Romain.

It is a bit hacky, but that does work to an extent. Nice touch with the soft hypen as the column header.

As someone fairly new to Looker, how do you change the background colour of the header bar in the table, however?

From the Edit menu on the right, choose the Table Theme that works for you.

I’m interested in that too, can you provide more info please! Can’t handle other forums, i know you can help!

Hi All,

Below html in LookML works fine for “SINGLE VALUE” Visualizations.

html:

{{ rendered_value }}

;;

Thanks,
Kaushal

Added a snapshot

9b98d86a63788e4585a53a22845c9365ce56ebae.png

Ah, so in order to be able to specify the size in the html we need to use rendered value, not value? Seems counter intuitive to mean, given the documentation refers to rendered value being the default formatting for Looker, but we can work with that.

Hey @Matthew_Darwin, you should also be able to use {{value}}. For example,

html: <p style="color: red; font-size: 50px"> {{ value }} </p> ;;

As you mentioned, rendered value is used when we want to apply Looker’s value formatting.

I know this is an old topic but doesn’t seem to be added as a feature? I’m looking for a way of doing this in the configuration of the tile and not in a static way (i.e. via LookML code)

Note that you could use the new Multiple Value Visualization from the marketplace. You can display just one value with it and have the ability to set the font size.

As few of them mentioned above , I got this done by (along with adding links and making it bold)
html: <p style="font-size: 85px"><b><a href="URL">{{rendered_value}}</a></b></p> ;;

If its still not working , check :

  • If you have added Value Format - in your visualisation (0, 0# etc) . Remove it (instead add it In dimension/measure definition) , because thats somehow overriding the above html code.

Thanks Annie for helping out on this 😃

abhineet1
Participant I

Is it possible to change the font size in Single Value viz of the looker without LookML. or is there any custom viz available in market as an option for this.

Our users likewise are interested in being able to customize the font size of visualizations - we often display Looker dashboards on TV screens and being able to customize font size would greatly contribute to visibility.

sunnygudVZ
Participant I

Is there a hack to show the text at the bottom darker than what it shows? i am using a single value look.

Any help is appreciated. 

Somehow the title shows opaque with 30-50% transparency i believe, i hope there is an easier way to fix this.

 

65e8935e-2802-4584-819f-43e750093eb2.png

tuddin
Participant I

Is there a hack to show the text at the bottom darker than what it shows? i am using a single value look.

Any help is appreciated. 

Somehow the title shows opaque with 30-50% transparency i believe, i hope there is an easier way to fix this.

 

65e8935e-2802-4584-819f-43e750093eb2.png

I am also looking for the same. Could not find any solution yet. And I don’t link lookML based hacks to solve these problems. The same measure can be used in different places/viz. So I don’t want to control it in the model. 

One workaround would be to select a Multi Value visualization and then remove all fields except one you want. We can then adjust font size from the visualization settings

n_davis
Participant V

Is there a hack to show the text at the bottom darker than what it shows? i am using a single value look.

Any help is appreciated. 

Somehow the title shows opaque with 30-50% transparency i believe, i hope there is an easier way to fix this.

 

65e8935e-2802-4584-819f-43e750093eb2.png

I am also looking for the same. Could not find any solution yet. And I don’t link lookML based hacks to solve these problems. The same measure can be used in different places/viz. So I don’t want to control it in the model. 

You’ll want to use html for a single value viz font size change. You’ll take the measure and add html to it for font size, color, text, etc.

For situations where I have more than one row, I do things like:

html: <div class="vis">
<div class="vis-single-value" style="line-height: 1;font-size: 17px; text-align:center;color:black;" >
</div>
</div>;;

and then you can add your rendered value and texts into the html. 

@tuddin @sunnygudVZ 

I know this is an old topic, but I would also really like this feature.
I’m looking for a way of doing this in the configuration of the tile and not in a static way (i.e. via LookML code). I know it is possible to do so in the Multiple Value Visualization, but here it is not possible to do comparison numbers as it is for the single value visualization. 

Looking forward to hearing from you. 

Bump on this request! ?

Hope we can have more flexibility to adjust the Single Value Vis

Agreed.  I could use this feature now, that is the ability to adjust font size on a Google Looker fixed-size list.  Font size is specified on the Google Looker drop-down list, so it should be on the fixed-size list, too.  If this can be added in the future, please do so!

Top Labels in this Space
Top Solution Authors