Hide nulls values in legend in charts

[0li5a3a]

Hello,

is there any way to hide the nulls values in legend but stii to display the months where we have no values?

Please find below

I did checked the  Suppress Zero- Values from Presentation but when I do this all the nulls goes including the months with no data.

Any advice?

Regards,

C

[MK_QSL]

are you using Calculated Dimension?

Are you using two dimension?

can you provide exact dimension and expression you are using?

or provide sample app.

[0li5a3a · Accepted solution]

HI,

I use 2 dimensions, Month and Source.  I just figure out that if I use iF(iSNULL(Source),,'',Source)  the charts looks good

 

Thanks

[msmichael]

Thank you soooooo much for sharing this. I got exactly same issue and could not solve it for days... your solution really helped me a looooot! 🙂