Zero Values not showing for the Bar chart

[prakash11440278]

Hi Team

I am facing an Issue in Bar charts with zero values. We have an Incident data for December 17 to May 31, where we are extracing from the remedy. After building all barcharts, i have a strange issue in some of the months data is missing due to no data populated for this. For that missing data in the bar charts i want zero to populated. I tried adding all the respective measure & Columns by "+0" and in Axis right click - show items with no data & the formula IF(Column=blank(),0,Column), this are affecting the other columns & Measures. Is this bug or known error. Please help. Attached is the Screen shot for your reference.I want to show Zero values for the No data region

[Anonymous]

HI @prakash11440278,

If your table not contains these records, it is impossible to direct displya these missed records.

Please create a calenar table and link to original table, then you can use calendar date as axis and use measure with '+0' to expand blank records.

Notice: 0 and blank value not display on chart, please use table to see detail effect.

Regard,
Xiaoxin Sheng

[prakash11440278 · Accepted solution]

Hi v-shex-msft,

Thanks for your reply.

In my scenario i have 4 date columns(Closed Date, Resolved Date, Arrival Date..etc), all columns are pointing to different visualization, due to these it is not possible to create calander table and link to original table. "+0" is working fine for those bar charts who doesnot added as legend. But in my case i have added priority as legend, due to this field i am not able to show 0 values in my visualizations. Attaching the Issue Screen shot, which zero values are not showing.