Forum Discussion
Removing whitespace/gaps from clustered column chart with multiple calculated measure values
Hi all - I have a clustered column chart, along the x-axis are the months and for the y-axis values I have 6 calculated measures. In each given month there will only be 4 of the measures which have values, however there is whitespace for where the other 2 measures have no values - is there a way of removing this whitespace/gaps on the graph? So far I have tried to create a few other measures that return blank values if empty but this still doesn't remove the gaps. Any help would be greatly appreciated, thanks
An example of one of the measures:
Example Measure = CALCULATE(AVERAGE('ScoreTable'[Score]), 'ScoreTable'[Scenario (groups)] = "xxxx")
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Anonymous - I thought this might be the answer, but good to know nonetheless that this particular design cannot be altered
