Forum Discussion

LukeDurrant's avatar
LukeDurrant
Frequent Visitor
2 years ago
Solved

Remove data from Line chart

Hello, i hope everyone is well! Im trying to produce a line chart which cuts off where the red line is. In May 2024, there is data in there but the data for June 2024 is 0. Is there a way to not sho...
  • Alex87's avatar
    2 years ago

    Hello,

    Use this logic for your sum of Actuals

    FilteredValue = 
    IF (
        SUM('YourTable'[Value]) = 0,
        BLANK(),
        SUM('YourTable'[Value])
    )

     

  • rajendraongole1's avatar
    2 years ago

    Hi LukeDurrant - you can try Alex87  suggested, alternative without creating another measure there is a way by exclude data points with a value of 0 in visual-level filters

    For Sum of Actual, set it to "is not 0".

     

    Hope it works

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!