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 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")




2 Replies

  • 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