Forum Discussion
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...
Hello,
Use this logic for your sum of Actuals
FilteredValue = IF ( SUM('YourTable'[Value]) = 0, BLANK(), SUM('YourTable'[Value]) )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!!
Hello,
Use this logic for your sum of Actuals
FilteredValue =
IF (
SUM('YourTable'[Value]) = 0,
BLANK(),
SUM('YourTable'[Value])
)
Hi Alex, exactly what i needed! Thanks for the quick response 🙂