Removing whitespace/gaps from clustered column chart with multiple calculated measure values

Hi Henryrandalf ,

According to your screenshot, I think your issue is that the six group source may not always have data in each month, so you want to hide the blank in your column chart.

As far as I know, this is by design. Here I create a sample to explain to you.

For example, there are six category in my sample. We find that in April all categories have data. 

Since you created measures for each category, Power BI will sort your columns in the order in which you added the measures in the Y axis.
Since the column ordering is fixed, some categories will be blank when they have no values in a particular month. The blanks here are telling us that the category has no value in this month and is by design. So it cannot be removed.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.