Hi All - Is there a way to suppress zero values from displaying on a NUX line graph? Thanks!
Go to the source and in the format -> blueprint -> select blank when zero in the format.Hope this helps.Mark it as Solved if this works.
Thank you! This approach removes the data label but the chart still plots the zeros. I'm looking for a way to stop the zeros from being plotted if that's possible.
@JessicaD is this what you are looking for?Hope this was helpfulAnurag
The only way to do this from the UX only is to turn off the plotting of trailing zeros (suggested by @Anurag0911). However, this does not help you with any other zero values.
Expanding a bit on the suggestion by @ankit_cheeni to filter out zeros from the chart, you can actually "trick" Anaplan to avoid plotting a zero value by replacing your 0's with NaN's. While you can't manually enter NaN into a line item, you can write a formula that will return NaN. I suggest adding a NaN value to a System constants module so you can use it across your model as needed.
One example of a formula to generate a NaN:
DIVIDE(0,0)
See below post for mocked up example.
Additional resources/credits:
Expanding my above message with a mocked up example.
Constants module with a NaN value:
Data module with values:
System module with logic to check for zeros:
Additional line item showing NaN values in place of zeros:
Final output in the UX (comparing the two line items):
Brilliant! This worked perfectly! My graph no longer plots the zeros but rather starts from the first data point. Thank you for this solution!
Thank you @Anurag0911 This solution works if the zeros are at the end. In my use case, the zeros were in the beginning. This is really helpful though for graphs with trailing zeros.
FYI I have documented the steps in this solution in a How To article: https://community.anaplan.com/t5/How-To/Suppressing-zeros-in-line-charts/ta-p/143610
I love how creative the community members are. This is great, thank you for this.
Incredible solution. Very nice work!
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
