Separate columns

[OttoKnoke]

Hi,

I have a column chart visual with two columns. Is it possible to separate the columns on the x-axis? Thanks in advance for any help.

[v-yalanwu-msft · Accepted solution]

Hi, @OttoKnoke ;

Clustered column chart aligns with each labels and group by legends, not support auto fit them. I'd like to suggest you post this requirement to ideas.
Or  you could add another table such as:
1. create a table.

Legend = ADDCOLUMNS( UNION( VALUES('financials'[Year]),{BLANK()}),"rank",IF([Year]=2013,1,IF([Year]=2014,3,2)))

 2.create a measure.

sum = CALCULATE(SUM(financials[ Sales]),FILTER('financials',[Year]=MAX('Legend'[Year])))+0

3. sort by rank column.

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @OttoKnoke ;

You could add a blank measure then put it into visual.

Measure = BLANK()

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[OttoKnoke]

Thanks, I did your solution, but who does for the blank measure to not show in the legend? 

[jennratten]

If you have related dimension tables you can add a column from the dimension table to separate the x axis.  In your example above, you should have a measure created for the sum of the amount and a related dimension table with a column containing open/closed.  The example below shows a column chart with a measure in the value and three dimensions on the x-axis.