How to Remove unwanted 0 Values in a Chart.

[Nethu_Rajapaksha]

Hi Experts,

Please refer the below screen shot. I just want to "remove this light blue line". How do I solve this? In my data set there is no such zero values for the evening shift ( Light Blue Line). Only contains the vales for the "General Shift". Could you please explain why it happens and How do I fix this? 

[TauseefKhan]

In Data Handling Uncheck Box (Include Zero value ) or you can put expression.

****Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.****

[Nethu_Rajapaksha]

Hi TauseefKhan,

Yes I tried this before. But still having the same issue.!

[Brian_C]

Hi 

You can amend your expression to be If(sum([Evening Shift])>0,sum([Evening Shift]))

Simply replace [Evening Shift] with the name of your master measure or expression.

Hope this helps you.

Brian

[Pablo007]

Dear @Nethu_Rajapaksha ,

If you just want to show on the charte "General Shift" just delete the other meassures from the chart

Go to edit

Clik on your chart 

And look for measures (and on the right side of your screen

Mouse right button Click => delete

[Nethu_Rajapaksha]

Hi @Brian_C 

Thanks for commenting. I tried that with the fallowing code. But still having the same issue..

IF(SUM({< [Team Type] = {'Laying'}, Shift = {'General Shift'} >} [Units Completed]) > 0,
SUM({< [Team Type] = {'Laying'}, Shift = {'General Shift'} >} [Units Completed])
) +
IF(SUM({< [Team Type] = {'Laying'}, Shift = {'OM GEN 2'} >} [Units Completed]) > 0,
SUM({< [Team Type] = {'Laying'}, Shift = {'OM GEN 2'} >} [Units Completed])
)

[Brian_C · Accepted solution]

Hi

Try IF(SUM({< [Team Type] = {'Laying'}, Shift = {'General Shift'} >} [Units Completed])+

SUM({< [Team Type] = {'Laying'}, Shift = {'OM GEN 2'} >} [Units Completed]) > 0,

SUM({< [Team Type] = {'Laying'}, Shift = {'General Shift'} >} [Units Completed])+

SUM({< [Team Type] = {'Laying'}, Shift = {'OM GEN 2'} >} [Units Completed]))

Kindest regards

Brian

[Nethu_Rajapaksha]

Hi @Brian_C 

      Thank you so much for your help! Your solution worked perfectly and saved me a lot of time.!

[Brian_C]

Your very welcome. Happy to help.