QS line chart how to remove null value when most recent period value = 0

[paulyeo11]

Hi All

i have a line chart to display exp amount by YearQtr.

for 2016 Q4 2016 Q3 2016 Q2 2016 Q1 all are 0 value.

it is possible to remove null value , so that my chart left side will start with Q4 2015 instead of 2016 Q4.

My i know how to set ?

Paul

[sunny_talwar · Accepted solution]

May be by unchecking the 'Show Zero Value' option under Add-ons -> Data Handling

The only issue is that it will hide 0's in any other period also. If that's not what you want, then we will have to explore other options.

[swuehl]

Go to Chart Properties - Add Ons - Data processing  - Disable 'Show Null values'

[paulyeo11]

Hi All

thank you for your help. it work

Paul