# Larger spaces between groups on charts

**URL:** <https://community.fibery.io/t/larger-spaces-between-groups-on-charts/3204>\
**Category:** Get Help\
**Created:** [August 23, 2022, 2:10pm UTC](https://community.fibery.io/t/larger-spaces-between-groups-on-charts/3204 "2022-08-23T14:10:14Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [August 23, 2022, 2:10pm UTC](https://community.fibery.io/t/larger-spaces-between-groups-on-charts/3204/1 "2022-08-23T14:10:14Z")

</div>

I have created a bar chart for year over year comparisons. Data is grouped by month and year. However, the gap between January’s bars is large and Jan 21 is right next to Feb 22. It would make more sense if the two bars for each month were closer together and a larger gap existed between months.  
I’ve attached a screenshot for reference.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/5/54e218dbede47840bc20708cd46c32c1d1ee394c.png)

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [August 23, 2022, 2:22pm UTC](https://community.fibery.io/t/larger-spaces-between-groups-on-charts/3204/2 "2022-08-23T14:22:11Z")

</div>

How is the grouping achieved?  
Are the months fields in the database?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [August 23, 2022, 2:37pm UTC](https://community.fibery.io/t/larger-spaces-between-groups-on-charts/3204/3 "2022-08-23T14:37:32Z")

</div>

I assume that you’re using `YEAR([DATE])` for the year value.  
You could try using the following instead, it will group the numbers 2021 and 2022 closer together

```auto
BINS(
	DATEPART(
		[Date],
		'Year'
	),
	1
)

```

It doesn’t increase the gap between the month groups, but at least the gaps will be similar.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [August 23, 2022, 2:40pm UTC](https://community.fibery.io/t/larger-spaces-between-groups-on-charts/3204/4 "2022-08-23T14:40:25Z")

</div>

![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/c/cfb4ca0b59e7073b579279bf212d6c0c81dadeda.png)

---

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [August 23, 2022, 5:47pm UTC](https://community.fibery.io/t/larger-spaces-between-groups-on-charts/3204/5 "2022-08-23T17:47:12Z")

</div>

This looks like a great solution! I’ll keep you posted

---

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [August 23, 2022, 6:29pm UTC](https://community.fibery.io/t/larger-spaces-between-groups-on-charts/3204/6 "2022-08-23T18:29:50Z")

</div>

The visual experience is much improved _but_ you lose the year over year computation when hovering using the Intervals. Fibery no longer computes the change and shows a red or green arrow when hobering over the bars.

![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/e/e6e87288d9a181ce97f56a3aa760bfa6d58d4463.png)

I just circled back to this

> [@Chr1sG](#):
>
> How is the grouping achieved?

and I have a solution:  
The grouping is achieved by creating a Month parameter `MONTH([Date])` then adding a Year parameter `YEAR([Date])`  
Not sure that I noticed this until today, but changing the scale from continuous to period helped bring the columns closer together

![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/f/f4895c3a97fee13db9313fb6a97b1b7fff98cb24.png)

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [April 29, 2025, 11:22am UTC](https://community.fibery.io/t/larger-spaces-between-groups-on-charts/3204/7 "2025-04-29T11:22:28Z")

</div>