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

[Henryrandalf]

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 on the graph? Any help would be greatly appreciated, thanks 🙂

An example of one of the measures:

Example Measure = CALCULATE(AVERAGE('ScoreTable'[Score]), 'ScoreTable'[Scenario (groups)] = "xxxx")

[ahadkarimi]

@Henryrandalf, try this measure and let me know if there is any problem.

Example Measure = 
IF(
    ISBLANK(
        CALCULATE(
            AVERAGE('ScoreTable'[Score]), 
            'ScoreTable'[Scenario (groups)] = "xxxx"
        )
    ),
    BLANK(),
    CALCULATE(
        AVERAGE('ScoreTable'[Score]), 
        'ScoreTable'[Scenario (groups)] = "xxxx"
    )
)

[Henryrandalf]

Hi @ahadkarimi thanks for the above, unfortunately when changing my measures to be like the above and putting them as values on the clustered column charts there are still empty spaces for those months which dont have data for some of the measures