Remove data from Line chart

[LukeDurrant]

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 show data with a 0 on the line chart?

Thanks!

[Alex87 · Accepted solution]

Hello,

Use this logic for your sum of Actuals

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

[rajendraongole1 · Accepted solution]

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!!

[LukeDurrant]

Hello! This has also got me to the result i needed! Thanks for the help 🙂

[Alex87 · Accepted solution]

Hello,

Use this logic for your sum of Actuals

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

[LukeDurrant]

Hi Alex, exactly what i needed! Thanks for the quick response 🙂