Forum Discussion

Henryrandalf's avatar
Henryrandalf
Regular Visitor
2 years ago

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 v...
ahadkarimi's avatar
ahadkarimi
Solution Specialist
2 years ago

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's avatar
Henryrandalf
Regular Visitor
2 years ago

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