Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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.****
Hi TauseefKhan,
Yes I tried this before. But still having the same issue.!
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
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
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])
)
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
Hi @Brian_C
Thank you so much for your help! Your solution worked perfectly and saved me a lot of time.!
Your very welcome. Happy to help.