Show excluded value in line chart dim

[Rothschild]

Hi,

I created  a line chart with field 'Year' in Dimension, and Sum(Sales) as Experssion.

I want to see also exscluded years with zero value in Experssion.

How can I do that?

Thanks!!

 I want to see 2014 also.

[rushikale0106]

Hello @Rothschild ,

To solve your query, go to Chart properties of your Line Chart.

There go to the Dimensions tab and Uncheck the "Suppress When Value Is Null" option. Also, recheck on the Presentation tab for Suppress Zero-Values.

This must solve your query. Let me know if you face anything else with this.

Regards,

Rushika

[Rothschild]

Hi @rushikale0106 ,

Thank you for responding, but uncheck suppress null connot help here.

My main key in the QV model is Entity&YYYYMM.

I don't have record with 2014MM with null fields - I don't have a record to this entity  in 2014 at all.

Do you undrstand the differance?

[rushikale0106 · Accepted solution]

Hi @Rothschild ,

Yes. I guess I understand your question. You don't have any value with 2014 field.

Try to use this equation with your dimension where the no value is available as Null.

=if(isnull(column_name), '0', column_name_or_anything_you_want_to_display) 

This might solve your problem. Let me know if it's still not working.

Regards,

Rushika