# Index pattern to format a field

**URL:** https://discuss.elastic.co/t/index-pattern-to-format-a-field/181284
**Category:** Kibana
**Tags:** canvas
**Created:** [May 16, 2019, 12:14am UTC](https://discuss.elastic.co/t/index-pattern-to-format-a-field/181284 "2019-05-16T00:14:07Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![gbarnett](https://avatars.discourse-cdn.com/v4/letter/g/ac91a4/32.png) [@gbarnett](https://discuss.elastic.co/u/gbarnett)
#### Post date: [May 16, 2019, 12:14am UTC](https://discuss.elastic.co/t/index-pattern-to-format-a-field/181284/1 "2019-05-16T00:14:07Z")

</div>

For my index, I have created an index pattern so that my ‘payment’ field will format as $0.00. However, when I display my payment value in a Metric widget in Canvas, the format is not honored. That is, the format is ignored.

Interestingly, I loaded the kibana\_sample\_data\_ecommerce dataset and sample canvases, and it has the same issue. It’s ‘taxable\_total\_price’ field has a custom format defined in the index pattern, but when I use this field in the canvas, this custom formatting is ignored or not applied.

I must be missing something. Why are the custom formats defined in the index patterns not applied when the associated field is displayed in a csnvas?

---

<div class="post-metadata">

### Author: ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)
#### Post date: [May 16, 2019, 5:29pm UTC](https://discuss.elastic.co/t/index-pattern-to-format-a-field/181284/2 "2019-05-16T17:29:48Z")

</div>

@gbarnett Canvas does not use the index-pattern configuration of Kibana, as it is directly hitting the underlying indices with the SQL expressions.

I'd create an enhancement request for this [https://github.com/elastic/kibana/issues/new](https://github.com/elastic/kibana/issues/new)

---

<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: [June 13, 2019, 5:30pm UTC](https://discuss.elastic.co/t/index-pattern-to-format-a-field/181284/3 "2019-06-13T17:30:02Z")

</div>

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