Problem with Bar chart - on selection columns with null value getting disappeared. How to show columns with null values

[#1]

Hi

I am creating a bar chart between 12 months of a year and amount spent by a person. For a particular person the data is present only for month of nov and for rest of the months the amount spent is null. On selecting that person my bar chart squeezes to show the data for the month of nov only.

I want to show the other months which are having null values. How can i achieve this scenario.Please help

Thanks

Vitul

[tresesco]

Did you try unchecking 'Supress Missing' in presentation tab?

[maxgro]

and 'Show All Values' in Dimensions tab?

[#4]

Thanks Tresesco for your suggestion......but it is not working....

[#5]

Thanks Massimo.... but it is not working

[tresesco]

Could you post your app sample that demonstrates the issue?

[sundarakumar]

Hi Vitul,

Please find the attachment.

I have used set analysis and background colour option to get this work.

Hope this helps.

-Sundar