Display missing bars in a bar chart

[manideep78]

Dear Community,

I wanted to show the bar chart with 2 dimensions like a below image:

But here, for the first dimension some values are missing in second dimension (marked in the red circle) and it show empty with out even showing a zero value.

can you please suggest me know how can I display the missing second dimension with 0 value.

any help would be appreciated.

Thanks in advance.

Regards,

Manideep

[sunny_talwar]

I guess none of the techniques mentioned above won't work with missing data. you will have to convert missing data into null data to make this to work. Having said that, I would encourage you to seek other people advice, because I may not know if there is a way to do this. May be someone have a way to figure this out, but I am not aware of any way to do this

[manideep78]

That's great Sunny. Thanks. I appreciate your help!

[manideep78]

Hi Rahul,

I tried this expression already and found no luck.

Regards,

Manideep

[MarcoWedel]

Hi,

maybe one solution might be:

hope this helps

regards

Marco