How to full fill zero on the chart?

[panwipa2528]

Need to full fill zero as sample

Need like this

[mayankraoka]

Hi,

Another way is to do it on pivot table attached screenshot for reference:

Regards,

Mayank

[panwipa2528]

My customer need to present in chart.

[mayankraoka]

For that you need to create rows with null values for every non-existing combination of the key.Then the sum on null should work and return 0 .For this just check show all values for dimensions.

Regards,

Mayank

[panwipa2528]

already check but it not work.

[kavita25]

What are your dimensions as per the excel?

[Sergey_Shuklin]

Hello!

Check "Show Zero Values" on Presentation tab. Should work.

[kavita25]

Unchecked Suppress Zero-Values, Suppress Missing.. under presentation tab.

And checked Zero on Bars...

[panwipa2528]

Not working

[kavita25]

uncheck suppress missing