# Kibana not showing csv data properly

**URL:** <https://discuss.elastic.co/t/kibana-not-showing-csv-data-properly/233429>\
**Category:** Kibana\
**Created:** [May 20, 2020, 12:58am UTC](https://discuss.elastic.co/t/kibana-not-showing-csv-data-properly/233429 "2020-05-20T00:58:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tenet\_testuser1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tenet_testuser1/32/67526_2.png) [@tenet\_testuser1](https://discuss.elastic.co/u/tenet_testuser1)\
**Post date:** [May 20, 2020, 12:58am UTC](https://discuss.elastic.co/t/kibana-not-showing-csv-data-properly/233429/1 "2020-05-20T00:58:08Z")

</div>

Hello,

my csv file is not faithfully reproduced in Kibana.

The metrics are shifted down by one row in reference to date so my may 15 2020 shows for may 14 and may 14th shows up in may 13 and so on.

How do I fix this?

---

<div class="post-metadata">

**Author:** ![cheiligers](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cheiligers/32/73114_2.png) [@cheiligers](https://discuss.elastic.co/u/cheiligers)\
**Post date:** [June 4, 2020, 7:42pm UTC](https://discuss.elastic.co/t/kibana-not-showing-csv-data-properly/233429/2 "2020-06-04T19:42:04Z")

</div>

@tenet\_testuser1it this sounds like a mismatch in timezone. It might be that your dates in the documents are using a different timezone to that being displayed in your visualization. If that's the case, you'll want to make sure that you're using the same timezone in you visualizations as the timezone in your documents. You can change date preferences in the Management / Advanced settings page:

 ![Screen Shot 2020-06-04 at 12.40.38](https://us1.discourse-cdn.com/elastic/original/3X/5/6/56557908cd6f76cc9908134319114f223dee4f05.png)

---

<div class="post-metadata">

**Author:** ![tenet\_testuser1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tenet_testuser1/32/67526_2.png) [@tenet\_testuser1](https://discuss.elastic.co/u/tenet_testuser1)\
**Post date:** [June 5, 2020, 1:14am UTC](https://discuss.elastic.co/t/kibana-not-showing-csv-data-properly/233429/3 "2020-06-05T01:14:21Z")

</div>

I fixed the problem by changing the kibana browser time from client to UTC

---

<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:** [July 3, 2020, 1:14am UTC](https://discuss.elastic.co/t/kibana-not-showing-csv-data-properly/233429/4 "2020-07-03T01:14:26Z")

</div>

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