Forum Discussion
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 show data with a 0 on the line chart?
Thanks!
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!!
4 Replies
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 🙂
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! This has also got me to the result i needed! Thanks for the help 🙂
