# Kibana canvas metrics font not working

**URL:** <https://discuss.elastic.co/t/kibana-canvas-metrics-font-not-working/320262>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [December 1, 2022, 3:11pm UTC](https://discuss.elastic.co/t/kibana-canvas-metrics-font-not-working/320262 "2022-12-01T15:11:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![erloti](https://avatars.discourse-cdn.com/v4/letter/e/b77776/32.png) [@erloti](https://discuss.elastic.co/u/erloti)\
**Post date:** [December 1, 2022, 3:11pm UTC](https://discuss.elastic.co/t/kibana-canvas-metrics-font-not-working/320262/1 "2022-12-01T15:11:41Z")

</div>

Hello,  
I'm trying to create very simple metrics in canvas.  
I correctly set the data source et the SQL (data preview is showing the correct data).  
But whenever I try to add font in the expression, the value becomes '0' or '?'.  
Anyone can send me very simple font so I can try to use it ?

My expression is like this :  
filters "one" "two"  
| essql query="SELECT count(\*) FROM "_messages_""  
| metric "Count"  
metricFont={font family="'Open Sans', Helvetica, Arial, sans-serif" size=96 align="center" color="#000000" weight="normal"}  
labelFont={font family="'Open Sans', Helvetica, Arial, sans-serif" size=10 align="center" color="#000000" weight="normal"}

---

<div class="post-metadata">

**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\
**Post date:** [December 28, 2022, 12:30pm UTC](https://discuss.elastic.co/t/kibana-canvas-metrics-font-not-working/320262/2 "2022-12-28T12:30:16Z")

</div>

Maybe the issue is in the name of the column in your output?

I created a metric from kibana flights sample without issues, changing fonts and even adding a small margin with a custom CSS. See the `SELECT count(*) as row_count`

```auto
kibana
| selectFilter
| essql query="SELECT count(*) as row_count FROM \"kibana_sample_data_flights\""
| math "row_count"
| metric 
  metricFont={font align="center" color="#000000" family="'Lucida Grande', 'Lucida Sans Unicode', Lucida, Verdana, Helvetica, Arial, sans-serif" italic=false size=48 underline=false weight="normal"} 
  labelFont={font align="center" color="#000000" family="'Hoefler Text', Garamond, Georgia, 'Times New Roman', Times, serif" italic=false size=14 underline=false weight="normal"} metricFormat="0,0.[000]" "Rows count"
| render css=".canvasRenderEl
.canvasMetric__metric {
  margin-bottom: 15px;
}"

```

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/f/7feef8a757c3d41c24c3ded6904b84c18f1edd12.png)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 25, 2023, 12:30pm UTC](https://discuss.elastic.co/t/kibana-canvas-metrics-font-not-working/320262/3 "2023-01-25T12:30:19Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.