Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi , I understand that this question has been asked several times in the forum and many answers were given.
However it seems like none of them are working for me. Could anyone please help me in telling how not to show the zero data for the chart?
for the chart below, it should be not showing the yellow highlighted part, only till the value which is not zero.
I have tried to suppress the null values box and also update the measures with the formula
if (expression>0,expression). both cases do not work.
If it's zero then uncheck Include zero values:
Did you try it?
Hi @EliGohar ,
thanks for the reply.
I have already tried it.
its null value.
but still does not work.
Hi,
I have found a temp solution to my problem.
I changed the missing values to Show as Gaps from show as zeros together with unchecking the null values and zero values boxes and it seems to work for now. Could any experts here let me know if this is an acceptable solution?