How not to show the zero data in the chart.

[aashok]

Hi ,I have a chart as shown below. I do not want to show the line graph with the 0 % data shown in 2021.

How to change the expression to make it happen. 

This is the current expression for the line graph.

Sum({<[16 Category] = {'Resignation'} >}[16 SB_Avg_Reg_Rate])

If I use  the expression  in this manner,- if([16 SB_Avg_Reg_Rate]<>0,[16 SB_Avg_Reg_Rate],null()) it is not giving me the correct answer.

Could anyone help?

[rubenmarin · Accepted solution]

Hi, you can go tho chart properties -> add-ons -> remove the check to show zero values.

Or use this expression: If(Sum({<[16 Category] = {'Resignation'} >}[16 SB_Avg_Reg_Rate])<>0, Sum({<[16 Category] = {'Resignation'} >}[16 SB_Avg_Reg_Rate]))

[aashok]

@rubenmarin  I had tried the 1st option earlier.  It didn't work.not sure why. I have faced this  earlier too.

Anyway, the expression is fine. It works. Thank you.